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 (
    218476, 
    215713, 
    215714, 
    215715, 
    215716, 
    215738, 
    215731, 
    237036, 
    237037, 
    215717, 
    242135, 
    241141, 
    215718, 
    215719, 
    215720, 
    215721, 
    215722, 
    241142, 
    215723, 
    215724, 
    215725, 
    215726, 
    215727, 
    215728, 
    215729, 
    215730, 
    241143, 
    215732, 
    241144, 
    215733, 
    215734, 
    215735, 
    242136, 
    242137, 
    215736, 
    215737, 
    242138, 
    241145, 
    220318, 
    215376, 
    215377, 
    229116, 
    229117, 
    229118, 
    229119, 
    229899, 
    229896, 
    229897, 
    229898, 
    229950, 
    229942, 
    229943, 
    229944, 
    229961, 
    229953, 
    229954, 
    229955, 
    229972, 
    229964, 
    229965, 
    229966, 
    230173, 
    230175, 
    230174, 
    230380, 
    230351, 
    230379, 
    230352, 
    230353, 
    230354, 
    230355, 
    230356, 
    237066, 
    237067, 
    230357, 
    241720, 
    230358, 
    230359, 
    230360, 
    230361, 
    230362, 
    241721, 
    230363, 
    230364, 
    230365, 
    230366, 
    230367, 
    230368, 
    230369, 
    230370, 
    241722, 
    230371, 
    241723, 
    230372, 
    230373, 
    240475, 
    230374, 
    241724, 
    242868, 
    242869, 
    242870, 
    242871, 
    230986, 
    230957, 
    230958, 
    230959, 
    230960, 
    230980, 
    230961, 
    230962, 
    230963, 
    230964, 
    230965, 
    230966, 
    230967, 
    230968, 
    230969, 
    230970, 
    230971, 
    230972, 
    230973, 
    230974, 
    230975, 
    230976, 
    230977, 
    230978, 
    230979, 
    230981, 
    230982, 
    230983, 
    230984, 
    230985, 
    236833, 
    236829, 
    236830, 
    236831, 
    236832, 
    246045, 
    246019, 
    246020, 
    246021, 
    246022, 
    246044, 
    246037, 
    246046, 
    246047, 
    246023, 
    246053, 
    246048, 
    246024, 
    246025, 
    246026, 
    246027, 
    246028, 
    246049, 
    246029, 
    246030, 
    246031, 
    246032, 
    246033, 
    246034, 
    246035, 
    246036, 
    246050, 
    246038, 
    246051, 
    246039, 
    246040, 
    246054, 
    246055, 
    246041, 
    246042, 
    246043, 
    246056, 
    246052
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00226

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": 175,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (218476,215713,215714,215715,215716,215738,215731,237036,237037,215717,242135,241141,215718,215719,215720,215721,215722,241142,215723,215724,215725,215726,215727,215728,215729,215730,241143,215732,241144,215733,215734,215735,242136,242137,215736,215737,242138,241145,220318,215376,215377,229116,229117,229118,229119,229899,229896,229897,229898,229950,229942,229943,229944,229961,229953,229954,229955,229972,229964,229965,229966,230173,230175,230174,230380,230351,230379,230352,230353,230354,230355,230356,237066,237067,230357,241720,230358,230359,230360,230361,230362,241721,230363,230364,230365,230366,230367,230368,230369,230370,241722,230371,241723,230372,230373,240475,230374,241724,242868,242869,242870,242871,230986,230957,230958,230959,230960,230980,230961,230962,230963,230964,230965,230966,230967,230968,230969,230970,230971,230972,230973,230974,230975,230976,230977,230978,230979,230981,230982,230983,230984,230985,236833,236829,236830,236831,236832,246045,246019,246020,246021,246022,246044,246037,246046,246047,246023,246053,246048,246024,246025,246026,246027,246028,246049,246029,246030,246031,246032,246033,246034,246035,246036,246050,246038,246051,246039,246040,246054,246055,246041,246042,246043,246056,246052)"
        }
      }
    },
    "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
33888 215713 variant_image 46121 0 V 0 D 0 0
33889 215714 variant_image 46122 0 V 0 D 0 0
33890 215715 variant_image 46123 0 V 0 D 0 0
33891 215716 variant_image 46124 0 V 0 D 0 0
33892 215738 variant_image 46125 0 V 0 D 0 0
33893 215731 variant_image 46126 0 V 0 D 0 0
33894 215717 variant_image 46127 0 V 0 D 0 0
33895 215718 variant_image 46128 0 V 0 D 0 0
33896 215719 variant_image 46129 0 V 0 D 0 0
33897 215720 variant_image 46130 0 V 0 D 0 0
33898 215721 variant_image 46131 0 V 0 D 0 0
33899 215722 variant_image 46132 0 V 0 D 0 0
33900 215723 variant_image 46133 0 V 0 D 0 0
33901 215724 variant_image 46134 0 V 0 D 0 0
33902 215725 variant_image 46135 0 V 0 D 0 0
33903 215726 variant_image 46136 0 V 0 D 0 0
33904 215727 variant_image 46137 0 V 0 D 0 0
33905 215728 variant_image 46138 0 V 0 D 0 0
33906 215729 variant_image 46139 0 V 0 D 0 0
33907 215730 variant_image 46140 0 V 0 D 0 0
33908 215732 variant_image 46141 0 V 0 D 0 0
33909 215733 variant_image 46142 0 V 0 D 0 0
33910 215734 variant_image 46143 0 V 0 D 0 0
33911 215735 variant_image 46144 0 V 0 D 0 0
33912 215736 variant_image 46145 0 V 0 D 0 0
33913 215737 variant_image 46146 0 V 0 D 0 0
47268 229117 variant_image 59501 0 V 0 D 0 0
47269 229118 variant_image 59502 0 V 0 D 0 0
47270 229119 variant_image 59503 0 V 0 D 0 0
48494 229896 variant_image 60727 0 V 0 D 0 0
48495 229897 variant_image 60728 0 V 0 D 0 0
48496 229898 variant_image 60729 0 V 0 D 0 0
48537 229942 variant_image 60770 0 V 0 D 0 0
48538 229943 variant_image 60771 0 V 0 D 0 0
48539 229944 variant_image 60772 0 V 0 D 0 0
48547 229953 variant_image 60780 0 V 0 D 0 0
48548 229954 variant_image 60781 0 V 0 D 0 0
48549 229955 variant_image 60782 0 V 0 D 0 0
48557 229964 variant_image 60790 0 V 0 D 0 0
48558 229965 variant_image 60791 0 V 0 D 0 0
48559 229966 variant_image 60792 0 V 0 D 0 0
48928 230351 variant_image 61161 0 V 0 D 0 0
48929 230352 variant_image 61162 0 V 0 D 0 0
48930 230353 variant_image 61163 0 V 0 D 0 0
48931 230354 variant_image 61164 0 V 0 D 0 0
48932 230355 variant_image 61165 0 V 0 D 0 0
48933 230356 variant_image 61166 0 V 0 D 0 0
48934 230357 variant_image 61167 0 V 0 D 0 0
48935 230358 variant_image 61168 0 V 0 D 0 0
48936 230359 variant_image 61169 0 V 0 D 0 0
48937 230360 variant_image 61170 0 V 0 D 0 0
48938 230361 variant_image 61171 0 V 0 D 0 0
48939 230362 variant_image 61172 0 V 0 D 0 0
48940 230363 variant_image 61173 0 V 0 D 0 0
48941 230364 variant_image 61174 0 V 0 D 0 0
48942 230365 variant_image 61175 0 V 0 D 0 0
48943 230366 variant_image 61176 0 V 0 D 0 0
48944 230367 variant_image 61177 0 V 0 D 0 0
48945 230368 variant_image 61178 0 V 0 D 0 0
48946 230369 variant_image 61179 0 V 0 D 0 0
48947 230370 variant_image 61180 0 V 0 D 0 0
48948 230371 variant_image 61181 0 V 0 D 0 0
48949 230372 variant_image 61182 0 V 0 D 0 0
48950 230373 variant_image 61183 0 V 0 D 0 0
48951 230374 variant_image 61184 0 V 0 D 0 0
48956 230379 variant_image 61189 0 V 0 D 0 0
50126 230957 variant_image 62359 0 V 0 D 0 0
50127 230958 variant_image 62360 0 V 0 D 0 0
50128 230959 variant_image 62361 0 V 0 D 0 0
50129 230960 variant_image 62362 0 V 0 D 0 0
50130 230961 variant_image 62363 0 V 0 D 0 0
50131 230962 variant_image 62364 0 V 0 D 0 0
50132 230963 variant_image 62365 0 V 0 D 0 0
50133 230964 variant_image 62366 0 V 0 D 0 0
50134 230965 variant_image 62367 0 V 0 D 0 0
50135 230966 variant_image 62368 0 V 0 D 0 0
50136 230967 variant_image 62369 0 V 0 D 0 0
50137 230968 variant_image 62370 0 V 0 D 0 0
50138 230969 variant_image 62371 0 V 0 D 0 0
50139 230970 variant_image 62372 0 V 0 D 0 0
50140 230971 variant_image 62373 0 V 0 D 0 0
50141 230972 variant_image 62374 0 V 0 D 0 0
50142 230973 variant_image 62375 0 V 0 D 0 0
50143 230974 variant_image 62376 0 V 0 D 0 0
50144 230975 variant_image 62377 0 V 0 D 0 0
50145 230976 variant_image 62378 0 V 0 D 0 0
50146 230977 variant_image 62379 0 V 0 D 0 0
50147 230978 variant_image 62380 0 V 0 D 0 0
50148 230979 variant_image 62381 0 V 0 D 0 0
50149 230980 variant_image 62382 0 V 0 D 0 0
50150 230981 variant_image 62383 0 V 0 D 0 0
50151 230982 variant_image 62384 0 V 0 D 0 0
50152 230983 variant_image 62385 0 V 0 D 0 0
50153 230984 variant_image 62386 0 V 0 D 0 0
50154 230985 variant_image 62387 0 V 0 D 0 0
59567 236829 variant_image 71800 0 V 0 D 0 0
59568 236830 variant_image 71801 0 V 0 D 0 0
59569 236831 variant_image 71802 0 V 0 D 0 0
59570 236832 variant_image 71803 0 V 0 D 0 0
59782 237036 variant_image 72015 0 V 0 D 0 0
59783 237037 variant_image 72016 0 V 0 D 0 0
59813 237066 variant_image 72046 0 V 0 D 0 0
59814 237067 variant_image 72047 0 V 0 D 0 0
69522 240475 variant_image 81755 0 V 0 D 0 0
70676 241141 variant_image 82909 0 V 0 D 0 0
70677 241142 variant_image 82910 0 V 0 D 0 0
70678 241143 variant_image 82911 0 V 0 D 0 0
70679 241144 variant_image 82912 0 V 0 D 0 0
70680 241145 variant_image 82913 0 V 0 D 0 0
71274 241720 variant_image 83507 0 V 0 D 0 0
71275 241721 variant_image 83508 0 V 0 D 0 0
71276 241722 variant_image 83509 0 V 0 D 0 0
71277 241723 variant_image 83510 0 V 0 D 0 0
71278 241724 variant_image 83511 0 V 0 D 0 0
71698 242135 variant_image 83931 0 V 0 D 0 0
71699 242136 variant_image 83932 0 V 0 D 0 0
71700 242137 variant_image 83933 0 V 0 D 0 0
71701 242138 variant_image 83934 0 V 0 D 0 0
72477 242868 variant_image 84710 0 V 0 D 0 0
72478 242869 variant_image 84711 0 V 0 D 0 0
72479 242870 variant_image 84712 0 V 0 D 0 0
72480 242871 variant_image 84713 0 V 0 D 0 0
76223 246019 variant_image 88456 0 V 0 D 0 0
76224 246020 variant_image 88457 0 V 0 D 0 0
76225 246021 variant_image 88458 0 V 0 D 0 0
76226 246022 variant_image 88459 0 V 0 D 0 0
76227 246023 variant_image 88460 0 V 0 D 0 0
76228 246024 variant_image 88461 0 V 0 D 0 0
76229 246025 variant_image 88462 0 V 0 D 0 0
76230 246026 variant_image 88463 0 V 0 D 0 0
76231 246027 variant_image 88464 0 V 0 D 0 0
76232 246028 variant_image 88465 0 V 0 D 0 0
76233 246029 variant_image 88466 0 V 0 D 0 0
76234 246030 variant_image 88467 0 V 0 D 0 0
76235 246031 variant_image 88468 0 V 0 D 0 0
76236 246032 variant_image 88469 0 V 0 D 0 0
76237 246033 variant_image 88470 0 V 0 D 0 0
76238 246034 variant_image 88471 0 V 0 D 0 0
76239 246035 variant_image 88472 0 V 0 D 0 0
76240 246036 variant_image 88473 0 V 0 D 0 0
76241 246037 variant_image 88474 0 V 0 D 0 0
76242 246038 variant_image 88475 0 V 0 D 0 0
76243 246039 variant_image 88476 0 V 0 D 0 0
76244 246040 variant_image 88477 0 V 0 D 0 0
76245 246041 variant_image 88478 0 V 0 D 0 0
76246 246042 variant_image 88479 0 V 0 D 0 0
76247 246043 variant_image 88480 0 V 0 D 0 0
76248 246044 variant_image 88481 0 V 0 D 0 0
76249 246046 variant_image 88482 0 V 0 D 0 0
76250 246047 variant_image 88483 0 V 0 D 0 0
76251 246048 variant_image 88484 0 V 0 D 0 0
76252 246049 variant_image 88485 0 V 0 D 0 0
76253 246050 variant_image 88486 0 V 0 D 0 0
76254 246051 variant_image 88487 0 V 0 D 0 0
76255 246052 variant_image 88488 0 V 0 D 0 0
76256 246053 variant_image 88489 0 V 0 D 0 0
76257 246054 variant_image 88490 0 V 0 D 0 0
76258 246055 variant_image 88491 0 V 0 D 0 0
76259 246056 variant_image 88492 0 V 0 D 0 0