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, 
    221146, 
    221147, 
    221148, 
    232268, 
    232269, 
    232270, 
    232300, 
    232275, 
    232277, 
    232279, 
    232392, 
    232389, 
    232390, 
    232391, 
    232597, 
    244670, 
    244671, 
    244672, 
    244673, 
    244674, 
    244675, 
    244676, 
    244677, 
    232567, 
    232568, 
    232569, 
    232570, 
    232571, 
    232572, 
    237018, 
    237019, 
    232573, 
    245232, 
    241271, 
    232574, 
    232575, 
    232576, 
    232577, 
    232578, 
    241272, 
    232579, 
    232580, 
    232581, 
    232582, 
    232583, 
    232584, 
    232585, 
    232586, 
    241273, 
    232587, 
    241274, 
    232588, 
    232589, 
    245233, 
    245234, 
    232598, 
    232590, 
    232591, 
    245235, 
    232592, 
    241275, 
    232593, 
    232594, 
    232595, 
    232596, 
    232605, 
    232599, 
    232601, 
    232602, 
    232603, 
    232604, 
    232621, 
    232613, 
    232614, 
    232615, 
    232632, 
    232624, 
    232625, 
    232626, 
    232643, 
    232635, 
    232636, 
    232637, 
    232712, 
    232686, 
    232687, 
    232688, 
    232689, 
    232690, 
    232691, 
    241286, 
    241287, 
    232692, 
    245236, 
    241276, 
    232693, 
    232694, 
    232695, 
    232696, 
    232697, 
    241277, 
    232698, 
    232699, 
    232700, 
    232701, 
    232702, 
    232703, 
    232704, 
    232705, 
    241278, 
    232706, 
    241279, 
    232707, 
    232708, 
    245237, 
    245238, 
    232709, 
    232710, 
    232711, 
    245239, 
    241280, 
    232725, 
    244678, 
    244679, 
    244680, 
    244681, 
    244682, 
    244683, 
    244684, 
    244685, 
    232738, 
    244686, 
    244687, 
    244688, 
    244689, 
    244690, 
    244691, 
    244692, 
    244693, 
    232764, 
    232739, 
    232740, 
    232741, 
    232742, 
    232743, 
    232744, 
    241288, 
    241289, 
    232745, 
    245240, 
    241281, 
    232746, 
    232747, 
    232748, 
    232749, 
    232750, 
    241282, 
    232751, 
    232752, 
    232753, 
    232754, 
    232755, 
    232756, 
    232757, 
    232758, 
    241283, 
    232759, 
    241284, 
    232760, 
    232761, 
    245241, 
    232765, 
    245242, 
    232762, 
    232763, 
    245243, 
    241285, 
    232965, 
    232966, 
    232967, 
    232975, 
    232969, 
    232970
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00303

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": 187,
          "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,221146,221147,221148,232268,232269,232270,232300,232275,232277,232279,232392,232389,232390,232391,232597,244670,244671,244672,244673,244674,244675,244676,244677,232567,232568,232569,232570,232571,232572,237018,237019,232573,245232,241271,232574,232575,232576,232577,232578,241272,232579,232580,232581,232582,232583,232584,232585,232586,241273,232587,241274,232588,232589,245233,245234,232598,232590,232591,245235,232592,241275,232593,232594,232595,232596,232605,232599,232601,232602,232603,232604,232621,232613,232614,232615,232632,232624,232625,232626,232643,232635,232636,232637,232712,232686,232687,232688,232689,232690,232691,241286,241287,232692,245236,241276,232693,232694,232695,232696,232697,241277,232698,232699,232700,232701,232702,232703,232704,232705,241278,232706,241279,232707,232708,245237,245238,232709,232710,232711,245239,241280,232725,244678,244679,244680,244681,244682,244683,244684,244685,232738,244686,244687,244688,244689,244690,244691,244692,244693,232764,232739,232740,232741,232742,232743,232744,241288,241289,232745,245240,241281,232746,232747,232748,232749,232750,241282,232751,232752,232753,232754,232755,232756,232757,232758,241283,232759,241284,232760,232761,245241,232765,245242,232762,232763,245243,241285,232965,232966,232967,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
39613 221147 variant_image 51846 0 V 0 D 0 0
39614 221148 variant_image 51847 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
52958 232567 variant_image 65191 0 V 0 D 0 0
52959 232568 variant_image 65192 0 V 0 D 0 0
52960 232569 variant_image 65193 0 V 0 D 0 0
52961 232570 variant_image 65194 0 V 0 D 0 0
52962 232571 variant_image 65195 0 V 0 D 0 0
52963 232572 variant_image 65196 0 V 0 D 0 0
52964 232573 variant_image 65197 0 V 0 D 0 0
52965 232574 variant_image 65198 0 V 0 D 0 0
52966 232575 variant_image 65199 0 V 0 D 0 0
52967 232576 variant_image 65200 0 V 0 D 0 0
52968 232577 variant_image 65201 0 V 0 D 0 0
52969 232578 variant_image 65202 0 V 0 D 0 0
52970 232579 variant_image 65203 0 V 0 D 0 0
52971 232580 variant_image 65204 0 V 0 D 0 0
52972 232581 variant_image 65205 0 V 0 D 0 0
52973 232582 variant_image 65206 0 V 0 D 0 0
52974 232583 variant_image 65207 0 V 0 D 0 0
52975 232584 variant_image 65208 0 V 0 D 0 0
52976 232585 variant_image 65209 0 V 0 D 0 0
52977 232586 variant_image 65210 0 V 0 D 0 0
52978 232587 variant_image 65211 0 V 0 D 0 0
52979 232588 variant_image 65212 0 V 0 D 0 0
52980 232589 variant_image 65213 0 V 0 D 0 0
52981 232590 variant_image 65214 0 V 0 D 0 0
52982 232591 variant_image 65215 0 V 0 D 0 0
52983 232592 variant_image 65216 0 V 0 D 0 0
52984 232593 variant_image 65217 0 V 0 D 0 0
52985 232594 variant_image 65218 0 V 0 D 0 0
52986 232595 variant_image 65219 0 V 0 D 0 0
52987 232596 variant_image 65220 0 V 0 D 0 0
52988 232598 variant_image 65221 0 V 0 D 0 0
52989 232599 variant_image 65222 0 V 0 D 0 0
52991 232601 variant_image 65224 0 V 0 D 0 0
52992 232602 variant_image 65225 0 V 0 D 0 0
52993 232603 variant_image 65226 0 V 0 D 0 0
52994 232604 variant_image 65227 0 V 0 D 0 0
53001 232613 variant_image 65234 0 V 0 D 0 0
53002 232614 variant_image 65235 0 V 0 D 0 0
53003 232615 variant_image 65236 0 V 0 D 0 0
53011 232624 variant_image 65244 0 V 0 D 0 0
53012 232625 variant_image 65245 0 V 0 D 0 0
53013 232626 variant_image 65246 0 V 0 D 0 0
53021 232635 variant_image 65254 0 V 0 D 0 0
53022 232636 variant_image 65255 0 V 0 D 0 0
53023 232637 variant_image 65256 0 V 0 D 0 0
53069 232686 variant_image 65302 0 V 0 D 0 0
53070 232687 variant_image 65303 0 V 0 D 0 0
53071 232688 variant_image 65304 0 V 0 D 0 0
53072 232689 variant_image 65305 0 V 0 D 0 0
53073 232690 variant_image 65306 0 V 0 D 0 0
53074 232691 variant_image 65307 0 V 0 D 0 0
53075 232692 variant_image 65308 0 V 0 D 0 0
53076 232693 variant_image 65309 0 V 0 D 0 0
53077 232694 variant_image 65310 0 V 0 D 0 0
53078 232695 variant_image 65311 0 V 0 D 0 0
53079 232696 variant_image 65312 0 V 0 D 0 0
53080 232697 variant_image 65313 0 V 0 D 0 0
53081 232698 variant_image 65314 0 V 0 D 0 0
53082 232699 variant_image 65315 0 V 0 D 0 0
53083 232700 variant_image 65316 0 V 0 D 0 0
53084 232701 variant_image 65317 0 V 0 D 0 0
53085 232702 variant_image 65318 0 V 0 D 0 0
53086 232703 variant_image 65319 0 V 0 D 0 0
53087 232704 variant_image 65320 0 V 0 D 0 0
53088 232705 variant_image 65321 0 V 0 D 0 0
53089 232706 variant_image 65322 0 V 0 D 0 0
53090 232707 variant_image 65323 0 V 0 D 0 0
53091 232708 variant_image 65324 0 V 0 D 0 0
53092 232709 variant_image 65325 0 V 0 D 0 0
53093 232710 variant_image 65326 0 V 0 D 0 0
53094 232711 variant_image 65327 0 V 0 D 0 0
53119 232739 variant_image 65352 0 V 0 D 0 0
53120 232740 variant_image 65353 0 V 0 D 0 0
53121 232741 variant_image 65354 0 V 0 D 0 0
53122 232742 variant_image 65355 0 V 0 D 0 0
53123 232743 variant_image 65356 0 V 0 D 0 0
53124 232744 variant_image 65357 0 V 0 D 0 0
53125 232745 variant_image 65358 0 V 0 D 0 0
53126 232746 variant_image 65359 0 V 0 D 0 0
53127 232747 variant_image 65360 0 V 0 D 0 0
53128 232748 variant_image 65361 0 V 0 D 0 0
53129 232749 variant_image 65362 0 V 0 D 0 0
53130 232750 variant_image 65363 0 V 0 D 0 0
53131 232751 variant_image 65364 0 V 0 D 0 0
53132 232752 variant_image 65365 0 V 0 D 0 0
53133 232753 variant_image 65366 0 V 0 D 0 0
53134 232754 variant_image 65367 0 V 0 D 0 0
53135 232755 variant_image 65368 0 V 0 D 0 0
53136 232756 variant_image 65369 0 V 0 D 0 0
53137 232757 variant_image 65370 0 V 0 D 0 0
53138 232758 variant_image 65371 0 V 0 D 0 0
53139 232759 variant_image 65372 0 V 0 D 0 0
53140 232760 variant_image 65373 0 V 0 D 0 0
53141 232761 variant_image 65374 0 V 0 D 0 0
53142 232762 variant_image 65375 0 V 0 D 0 0
53143 232763 variant_image 65376 0 V 0 D 0 0
53144 232765 variant_image 65377 0 V 0 D 0 0
53354 232966 variant_image 65587 0 V 0 D 0 0
53355 232967 variant_image 65588 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
59762 237018 variant_image 71995 0 V 0 D 0 0
59763 237019 variant_image 71996 0 V 0 D 0 0
70806 241271 variant_image 83039 0 V 0 D 0 0
70807 241272 variant_image 83040 0 V 0 D 0 0
70808 241273 variant_image 83041 0 V 0 D 0 0
70809 241274 variant_image 83042 0 V 0 D 0 0
70810 241275 variant_image 83043 0 V 0 D 0 0
70811 241276 variant_image 83044 0 V 0 D 0 0
70812 241277 variant_image 83045 0 V 0 D 0 0
70813 241278 variant_image 83046 0 V 0 D 0 0
70814 241279 variant_image 83047 0 V 0 D 0 0
70815 241280 variant_image 83048 0 V 0 D 0 0
70816 241281 variant_image 83049 0 V 0 D 0 0
70817 241282 variant_image 83050 0 V 0 D 0 0
70818 241283 variant_image 83051 0 V 0 D 0 0
70819 241284 variant_image 83052 0 V 0 D 0 0
70820 241285 variant_image 83053 0 V 0 D 0 0
70821 241286 variant_image 83054 0 V 0 D 0 0
70822 241287 variant_image 83055 0 V 0 D 0 0
70823 241288 variant_image 83056 0 V 0 D 0 0
70824 241289 variant_image 83057 0 V 0 D 0 0
74462 244670 variant_image 86695 0 V 0 D 0 0
74463 244671 variant_image 86696 0 V 0 D 0 0
74464 244672 variant_image 86697 0 V 0 D 0 0
74465 244673 variant_image 86698 0 V 0 D 0 0
74466 244674 variant_image 86699 0 V 0 D 0 0
74467 244675 variant_image 86700 0 V 0 D 0 0
74468 244676 variant_image 86701 0 V 0 D 0 0
74469 244677 variant_image 86702 0 V 0 D 0 0
74470 244678 variant_image 86703 0 V 0 D 0 0
74471 244679 variant_image 86704 0 V 0 D 0 0
74472 244680 variant_image 86705 0 V 0 D 0 0
74473 244681 variant_image 86706 0 V 0 D 0 0
74474 244682 variant_image 86707 0 V 0 D 0 0
74475 244683 variant_image 86708 0 V 0 D 0 0
74476 244684 variant_image 86709 0 V 0 D 0 0
74477 244685 variant_image 86710 0 V 0 D 0 0
74478 244686 variant_image 86711 0 V 0 D 0 0
74479 244687 variant_image 86712 0 V 0 D 0 0
74480 244688 variant_image 86713 0 V 0 D 0 0
74481 244689 variant_image 86714 0 V 0 D 0 0
74482 244690 variant_image 86715 0 V 0 D 0 0
74483 244691 variant_image 86716 0 V 0 D 0 0
74484 244692 variant_image 86717 0 V 0 D 0 0
74485 244693 variant_image 86718 0 V 0 D 0 0
75035 245232 variant_image 87268 0 V 0 D 0 0
75036 245233 variant_image 87269 0 V 0 D 0 0
75037 245234 variant_image 87270 0 V 0 D 0 0
75038 245235 variant_image 87271 0 V 0 D 0 0
75039 245236 variant_image 87272 0 V 0 D 0 0
75040 245237 variant_image 87273 0 V 0 D 0 0
75041 245238 variant_image 87274 0 V 0 D 0 0
75042 245239 variant_image 87275 0 V 0 D 0 0
75043 245240 variant_image 87276 0 V 0 D 0 0
75044 245241 variant_image 87277 0 V 0 D 0 0
75045 245242 variant_image 87278 0 V 0 D 0 0
75046 245243 variant_image 87279 0 V 0 D 0 0