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 (
    217618, 
    215378, 
    215379, 
    215380, 
    221143, 
    221144, 
    221145, 
    232268, 
    232269, 
    232270, 
    232300, 
    232275, 
    232277, 
    232279, 
    232392, 
    232389, 
    232390, 
    232391, 
    232612, 
    232606, 
    232608, 
    232609, 
    232610, 
    232611, 
    232807, 
    244702, 
    244703, 
    244704, 
    244705, 
    244706, 
    244707, 
    244708, 
    244709, 
    232777, 
    232778, 
    232779, 
    232780, 
    232781, 
    232782, 
    237008, 
    237009, 
    232783, 
    245244, 
    241290, 
    232784, 
    232785, 
    232786, 
    232787, 
    232788, 
    241291, 
    232789, 
    232790, 
    232791, 
    232792, 
    232793, 
    232794, 
    232795, 
    232796, 
    241292, 
    232797, 
    241293, 
    232798, 
    232799, 
    245245, 
    245246, 
    232808, 
    232800, 
    232801, 
    245247, 
    241294, 
    232802, 
    232803, 
    232804, 
    232805, 
    232806, 
    232817, 
    232809, 
    232810, 
    232811, 
    232828, 
    232820, 
    232821, 
    232822, 
    232839, 
    232831, 
    232832, 
    232833, 
    232908, 
    232882, 
    232883, 
    232884, 
    232885, 
    232886, 
    232887, 
    237016, 
    237017, 
    232888, 
    245248, 
    241295, 
    232889, 
    232890, 
    232891, 
    232892, 
    232893, 
    241296, 
    232894, 
    232895, 
    232896, 
    232897, 
    232898, 
    232899, 
    232900, 
    232901, 
    241297, 
    232902, 
    241298, 
    232903, 
    232904, 
    245249, 
    245250, 
    232905, 
    232906, 
    232907, 
    245251, 
    241299, 
    232921, 
    244710, 
    244711, 
    244712, 
    244713, 
    244714, 
    244715, 
    244716, 
    244717, 
    232934, 
    244718, 
    244719, 
    244720, 
    244721, 
    244722, 
    244723, 
    244724, 
    244725, 
    232960, 
    232935, 
    232936, 
    232937, 
    232938, 
    232939, 
    232940, 
    232941, 
    245252, 
    241300, 
    232942, 
    232943, 
    232944, 
    232945, 
    232946, 
    241301, 
    232947, 
    232948, 
    232949, 
    232950, 
    232951, 
    232952, 
    232953, 
    232954, 
    241302, 
    232955, 
    241303, 
    232956, 
    232957, 
    245253, 
    245254, 
    232961, 
    232958, 
    232959, 
    245255, 
    241304, 
    232975, 
    232969, 
    232970
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00239

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": 182,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (217618,215378,215379,215380,221143,221144,221145,232268,232269,232270,232300,232275,232277,232279,232392,232389,232390,232391,232612,232606,232608,232609,232610,232611,232807,244702,244703,244704,244705,244706,244707,244708,244709,232777,232778,232779,232780,232781,232782,237008,237009,232783,245244,241290,232784,232785,232786,232787,232788,241291,232789,232790,232791,232792,232793,232794,232795,232796,241292,232797,241293,232798,232799,245245,245246,232808,232800,232801,245247,241294,232802,232803,232804,232805,232806,232817,232809,232810,232811,232828,232820,232821,232822,232839,232831,232832,232833,232908,232882,232883,232884,232885,232886,232887,237016,237017,232888,245248,241295,232889,232890,232891,232892,232893,241296,232894,232895,232896,232897,232898,232899,232900,232901,241297,232902,241298,232903,232904,245249,245250,232905,232906,232907,245251,241299,232921,244710,244711,244712,244713,244714,244715,244716,244717,232934,244718,244719,244720,244721,244722,244723,244724,244725,232960,232935,232936,232937,232938,232939,232940,232941,245252,241300,232942,232943,232944,232945,232946,241301,232947,232948,232949,232950,232951,232952,232953,232954,241302,232955,241303,232956,232957,245253,245254,232961,232958,232959,245255,241304,232975,232969,232970)"
        }
      }
    },
    "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
33342 215378 variant_image 45575 0 V 0 D 0 0
33343 215379 variant_image 45576 0 V 0 D 0 0
33344 215380 variant_image 45577 0 V 0 D 0 0
39611 221144 variant_image 51844 0 V 0 D 0 0
39612 221145 variant_image 51845 0 V 0 D 0 0
52665 232275 variant_image 64898 0 V 0 D 0 0
52667 232277 variant_image 64900 0 V 0 D 0 0
52669 232279 variant_image 64902 0 V 0 D 0 0
52780 232389 variant_image 65013 0 V 0 D 0 0
52781 232390 variant_image 65014 0 V 0 D 0 0
52782 232391 variant_image 65015 0 V 0 D 0 0
52995 232606 variant_image 65228 0 V 0 D 0 0
52997 232608 variant_image 65230 0 V 0 D 0 0
52998 232609 variant_image 65231 0 V 0 D 0 0
52999 232610 variant_image 65232 0 V 0 D 0 0
53000 232611 variant_image 65233 0 V 0 D 0 0
53168 232777 variant_image 65401 0 V 0 D 0 0
53169 232778 variant_image 65402 0 V 0 D 0 0
53170 232779 variant_image 65403 0 V 0 D 0 0
53171 232780 variant_image 65404 0 V 0 D 0 0
53172 232781 variant_image 65405 0 V 0 D 0 0
53173 232782 variant_image 65406 0 V 0 D 0 0
53174 232783 variant_image 65407 0 V 0 D 0 0
53175 232784 variant_image 65408 0 V 0 D 0 0
53176 232785 variant_image 65409 0 V 0 D 0 0
53177 232786 variant_image 65410 0 V 0 D 0 0
53178 232787 variant_image 65411 0 V 0 D 0 0
53179 232788 variant_image 65412 0 V 0 D 0 0
53180 232789 variant_image 65413 0 V 0 D 0 0
53181 232790 variant_image 65414 0 V 0 D 0 0
53182 232791 variant_image 65415 0 V 0 D 0 0
53183 232792 variant_image 65416 0 V 0 D 0 0
53184 232793 variant_image 65417 0 V 0 D 0 0
53185 232794 variant_image 65418 0 V 0 D 0 0
53186 232795 variant_image 65419 0 V 0 D 0 0
53187 232796 variant_image 65420 0 V 0 D 0 0
53188 232797 variant_image 65421 0 V 0 D 0 0
53189 232798 variant_image 65422 0 V 0 D 0 0
53190 232799 variant_image 65423 0 V 0 D 0 0
53191 232800 variant_image 65424 0 V 0 D 0 0
53192 232801 variant_image 65425 0 V 0 D 0 0
53193 232802 variant_image 65426 0 V 0 D 0 0
53194 232803 variant_image 65427 0 V 0 D 0 0
53195 232804 variant_image 65428 0 V 0 D 0 0
53196 232805 variant_image 65429 0 V 0 D 0 0
53197 232806 variant_image 65430 0 V 0 D 0 0
53198 232808 variant_image 65431 0 V 0 D 0 0
53199 232809 variant_image 65432 0 V 0 D 0 0
53200 232810 variant_image 65433 0 V 0 D 0 0
53201 232811 variant_image 65434 0 V 0 D 0 0
53209 232820 variant_image 65442 0 V 0 D 0 0
53210 232821 variant_image 65443 0 V 0 D 0 0
53211 232822 variant_image 65444 0 V 0 D 0 0
53219 232831 variant_image 65452 0 V 0 D 0 0
53220 232832 variant_image 65453 0 V 0 D 0 0
53221 232833 variant_image 65454 0 V 0 D 0 0
53267 232882 variant_image 65500 0 V 0 D 0 0
53268 232883 variant_image 65501 0 V 0 D 0 0
53269 232884 variant_image 65502 0 V 0 D 0 0
53270 232885 variant_image 65503 0 V 0 D 0 0
53271 232886 variant_image 65504 0 V 0 D 0 0
53272 232887 variant_image 65505 0 V 0 D 0 0
53273 232888 variant_image 65506 0 V 0 D 0 0
53274 232889 variant_image 65507 0 V 0 D 0 0
53275 232890 variant_image 65508 0 V 0 D 0 0
53276 232891 variant_image 65509 0 V 0 D 0 0
53277 232892 variant_image 65510 0 V 0 D 0 0
53278 232893 variant_image 65511 0 V 0 D 0 0
53279 232894 variant_image 65512 0 V 0 D 0 0
53280 232895 variant_image 65513 0 V 0 D 0 0
53281 232896 variant_image 65514 0 V 0 D 0 0
53282 232897 variant_image 65515 0 V 0 D 0 0
53283 232898 variant_image 65516 0 V 0 D 0 0
53284 232899 variant_image 65517 0 V 0 D 0 0
53285 232900 variant_image 65518 0 V 0 D 0 0
53286 232901 variant_image 65519 0 V 0 D 0 0
53287 232902 variant_image 65520 0 V 0 D 0 0
53288 232903 variant_image 65521 0 V 0 D 0 0
53289 232904 variant_image 65522 0 V 0 D 0 0
53290 232905 variant_image 65523 0 V 0 D 0 0
53291 232906 variant_image 65524 0 V 0 D 0 0
53292 232907 variant_image 65525 0 V 0 D 0 0
53317 232935 variant_image 65550 0 V 0 D 0 0
53318 232936 variant_image 65551 0 V 0 D 0 0
53319 232937 variant_image 65552 0 V 0 D 0 0
53320 232938 variant_image 65553 0 V 0 D 0 0
53321 232939 variant_image 65554 0 V 0 D 0 0
53322 232940 variant_image 65555 0 V 0 D 0 0
53323 232941 variant_image 65556 0 V 0 D 0 0
53324 232942 variant_image 65557 0 V 0 D 0 0
53325 232943 variant_image 65558 0 V 0 D 0 0
53326 232944 variant_image 65559 0 V 0 D 0 0
53327 232945 variant_image 65560 0 V 0 D 0 0
53328 232946 variant_image 65561 0 V 0 D 0 0
53329 232947 variant_image 65562 0 V 0 D 0 0
53330 232948 variant_image 65563 0 V 0 D 0 0
53331 232949 variant_image 65564 0 V 0 D 0 0
53332 232950 variant_image 65565 0 V 0 D 0 0
53333 232951 variant_image 65566 0 V 0 D 0 0
53334 232952 variant_image 65567 0 V 0 D 0 0
53335 232953 variant_image 65568 0 V 0 D 0 0
53336 232954 variant_image 65569 0 V 0 D 0 0
53337 232955 variant_image 65570 0 V 0 D 0 0
53338 232956 variant_image 65571 0 V 0 D 0 0
53339 232957 variant_image 65572 0 V 0 D 0 0
53340 232958 variant_image 65573 0 V 0 D 0 0
53341 232959 variant_image 65574 0 V 0 D 0 0
53342 232961 variant_image 65575 0 V 0 D 0 0
53357 232969 variant_image 65590 0 V 0 D 0 0
53358 232970 variant_image 65591 0 V 0 D 0 0
59752 237008 variant_image 71985 0 V 0 D 0 0
59753 237009 variant_image 71986 0 V 0 D 0 0
59760 237016 variant_image 71993 0 V 0 D 0 0
59761 237017 variant_image 71994 0 V 0 D 0 0
70825 241290 variant_image 83058 0 V 0 D 0 0
70826 241291 variant_image 83059 0 V 0 D 0 0
70827 241292 variant_image 83060 0 V 0 D 0 0
70828 241293 variant_image 83061 0 V 0 D 0 0
70829 241294 variant_image 83062 0 V 0 D 0 0
70830 241295 variant_image 83063 0 V 0 D 0 0
70831 241296 variant_image 83064 0 V 0 D 0 0
70832 241297 variant_image 83065 0 V 0 D 0 0
70833 241298 variant_image 83066 0 V 0 D 0 0
70834 241299 variant_image 83067 0 V 0 D 0 0
70835 241300 variant_image 83068 0 V 0 D 0 0
70836 241301 variant_image 83069 0 V 0 D 0 0
70837 241302 variant_image 83070 0 V 0 D 0 0
70838 241303 variant_image 83071 0 V 0 D 0 0
70839 241304 variant_image 83072 0 V 0 D 0 0
74494 244702 variant_image 86727 0 V 0 D 0 0
74495 244703 variant_image 86728 0 V 0 D 0 0
74496 244704 variant_image 86729 0 V 0 D 0 0
74497 244705 variant_image 86730 0 V 0 D 0 0
74498 244706 variant_image 86731 0 V 0 D 0 0
74499 244707 variant_image 86732 0 V 0 D 0 0
74500 244708 variant_image 86733 0 V 0 D 0 0
74501 244709 variant_image 86734 0 V 0 D 0 0
74502 244710 variant_image 86735 0 V 0 D 0 0
74503 244711 variant_image 86736 0 V 0 D 0 0
74504 244712 variant_image 86737 0 V 0 D 0 0
74505 244713 variant_image 86738 0 V 0 D 0 0
74506 244714 variant_image 86739 0 V 0 D 0 0
74507 244715 variant_image 86740 0 V 0 D 0 0
74508 244716 variant_image 86741 0 V 0 D 0 0
74509 244717 variant_image 86742 0 V 0 D 0 0
74510 244718 variant_image 86743 0 V 0 D 0 0
74511 244719 variant_image 86744 0 V 0 D 0 0
74512 244720 variant_image 86745 0 V 0 D 0 0
74513 244721 variant_image 86746 0 V 0 D 0 0
74514 244722 variant_image 86747 0 V 0 D 0 0
74515 244723 variant_image 86748 0 V 0 D 0 0
74516 244724 variant_image 86749 0 V 0 D 0 0
74517 244725 variant_image 86750 0 V 0 D 0 0
75047 245244 variant_image 87280 0 V 0 D 0 0
75048 245245 variant_image 87281 0 V 0 D 0 0
75049 245246 variant_image 87282 0 V 0 D 0 0
75050 245247 variant_image 87283 0 V 0 D 0 0
75051 245248 variant_image 87284 0 V 0 D 0 0
75052 245249 variant_image 87285 0 V 0 D 0 0
75053 245250 variant_image 87286 0 V 0 D 0 0
75054 245251 variant_image 87287 0 V 0 D 0 0
75055 245252 variant_image 87288 0 V 0 D 0 0
75056 245253 variant_image 87289 0 V 0 D 0 0
75057 245254 variant_image 87290 0 V 0 D 0 0
75058 245255 variant_image 87291 0 V 0 D 0 0