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 (
    223749, 
    223750, 
    223751, 
    223752, 
    223753, 
    223754, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    223760, 
    223761, 
    223762, 
    225725, 
    225722, 
    225723, 
    225758, 
    225726, 
    225727, 
    225728, 
    225729, 
    225730, 
    225731, 
    237104, 
    237105, 
    225732, 
    242928, 
    241934, 
    225733, 
    225734, 
    225735, 
    225736, 
    225737, 
    241935, 
    225738, 
    225739, 
    225740, 
    225741, 
    225742, 
    225743, 
    225744, 
    225745, 
    241936, 
    225746, 
    241937, 
    225747, 
    225748, 
    242929, 
    242930, 
    225749, 
    225750, 
    225751, 
    241938, 
    242931, 
    225756, 
    225757, 
    225790, 
    225791, 
    225759, 
    225760, 
    225761, 
    225762, 
    225763, 
    237106, 
    237107, 
    225764, 
    242932, 
    241939, 
    225765, 
    225766, 
    225767, 
    225768, 
    225769, 
    241940, 
    225770, 
    225771, 
    225772, 
    225773, 
    225774, 
    225775, 
    225776, 
    225777, 
    241941, 
    225778, 
    241942, 
    225779, 
    225780, 
    242933, 
    242934, 
    225781, 
    225782, 
    225783, 
    242935, 
    241943, 
    225788, 
    225789, 
    225804, 
    225792, 
    225794, 
    225796, 
    225798, 
    225800, 
    225802, 
    225834, 
    225805, 
    225806, 
    225807, 
    225808, 
    225809, 
    225810, 
    225811, 
    237160, 
    237161, 
    225812, 
    242940, 
    241949, 
    225813, 
    225814, 
    225815, 
    225816, 
    225817, 
    241950, 
    225818, 
    225819, 
    225820, 
    225821, 
    225822, 
    225823, 
    225824, 
    225825, 
    241951, 
    225826, 
    241952, 
    225827, 
    225828, 
    242941, 
    242942, 
    225829, 
    225830, 
    225831, 
    242943, 
    241953, 
    225832, 
    225833, 
    236788, 
    236760, 
    236757, 
    236789, 
    236758, 
    236759, 
    236761, 
    237108, 
    237109, 
    236762, 
    242936, 
    241944, 
    236763, 
    236764, 
    236765, 
    236766, 
    236767, 
    241945, 
    236768, 
    236769, 
    236770, 
    236771, 
    236772, 
    236773, 
    236774, 
    236775, 
    241946, 
    236776, 
    241947, 
    236777, 
    236778, 
    242937, 
    242938, 
    236779, 
    236780, 
    236781, 
    242939, 
    241948, 
    236786, 
    236787
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00555

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": 185,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (223749,223750,223751,223752,223753,223754,223755,223756,223757,223758,223759,223760,223761,223762,225725,225722,225723,225758,225726,225727,225728,225729,225730,225731,237104,237105,225732,242928,241934,225733,225734,225735,225736,225737,241935,225738,225739,225740,225741,225742,225743,225744,225745,241936,225746,241937,225747,225748,242929,242930,225749,225750,225751,241938,242931,225756,225757,225790,225791,225759,225760,225761,225762,225763,237106,237107,225764,242932,241939,225765,225766,225767,225768,225769,241940,225770,225771,225772,225773,225774,225775,225776,225777,241941,225778,241942,225779,225780,242933,242934,225781,225782,225783,242935,241943,225788,225789,225804,225792,225794,225796,225798,225800,225802,225834,225805,225806,225807,225808,225809,225810,225811,237160,237161,225812,242940,241949,225813,225814,225815,225816,225817,241950,225818,225819,225820,225821,225822,225823,225824,225825,241951,225826,241952,225827,225828,242941,242942,225829,225830,225831,242943,241953,225832,225833,236788,236760,236757,236789,236758,236759,236761,237108,237109,236762,242936,241944,236763,236764,236765,236766,236767,241945,236768,236769,236770,236771,236772,236773,236774,236775,241946,236776,241947,236777,236778,242937,242938,236779,236780,236781,242939,241948,236786,236787)"
        }
      }
    },
    "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
42039 223756 variant_image 54272 0 V 0 D 0 0
42040 223757 variant_image 54273 0 V 0 D 0 0
42041 223758 variant_image 54274 0 V 0 D 0 0
42042 223759 variant_image 54275 0 V 0 D 0 0
42043 223761 variant_image 54276 0 V 0 D 0 0
42044 223762 variant_image 54277 0 V 0 D 0 0
43936 225722 variant_image 56169 0 V 0 D 0 0
43937 225723 variant_image 56170 0 V 0 D 0 0
43939 225726 variant_image 56172 0 V 0 D 0 0
43940 225727 variant_image 56173 0 V 0 D 0 0
43941 225728 variant_image 56174 0 V 0 D 0 0
43942 225729 variant_image 56175 0 V 0 D 0 0
43943 225730 variant_image 56176 0 V 0 D 0 0
43944 225731 variant_image 56177 0 V 0 D 0 0
43945 225732 variant_image 56178 0 V 0 D 0 0
43946 225733 variant_image 56179 0 V 0 D 0 0
43947 225734 variant_image 56180 0 V 0 D 0 0
43948 225735 variant_image 56181 0 V 0 D 0 0
43949 225736 variant_image 56182 0 V 0 D 0 0
43950 225737 variant_image 56183 0 V 0 D 0 0
43951 225738 variant_image 56184 0 V 0 D 0 0
43952 225739 variant_image 56185 0 V 0 D 0 0
43953 225740 variant_image 56186 0 V 0 D 0 0
43954 225741 variant_image 56187 0 V 0 D 0 0
43955 225742 variant_image 56188 0 V 0 D 0 0
43956 225743 variant_image 56189 0 V 0 D 0 0
43957 225744 variant_image 56190 0 V 0 D 0 0
43958 225745 variant_image 56191 0 V 0 D 0 0
43959 225746 variant_image 56192 0 V 0 D 0 0
43960 225747 variant_image 56193 0 V 0 D 0 0
43961 225748 variant_image 56194 0 V 0 D 0 0
43962 225749 variant_image 56195 0 V 0 D 0 0
43963 225750 variant_image 56196 0 V 0 D 0 0
43964 225751 variant_image 56197 0 V 0 D 0 0
43969 225756 variant_image 56202 0 V 0 D 0 0
43970 225757 variant_image 56203 0 V 0 D 0 0
43971 225759 variant_image 56204 0 V 0 D 0 0
43972 225760 variant_image 56205 0 V 0 D 0 0
43973 225761 variant_image 56206 0 V 0 D 0 0
43974 225762 variant_image 56207 0 V 0 D 0 0
43975 225763 variant_image 56208 0 V 0 D 0 0
43976 225764 variant_image 56209 0 V 0 D 0 0
43977 225765 variant_image 56210 0 V 0 D 0 0
43978 225766 variant_image 56211 0 V 0 D 0 0
43979 225767 variant_image 56212 0 V 0 D 0 0
43980 225768 variant_image 56213 0 V 0 D 0 0
43981 225769 variant_image 56214 0 V 0 D 0 0
43982 225770 variant_image 56215 0 V 0 D 0 0
43983 225771 variant_image 56216 0 V 0 D 0 0
43984 225772 variant_image 56217 0 V 0 D 0 0
43985 225773 variant_image 56218 0 V 0 D 0 0
43986 225774 variant_image 56219 0 V 0 D 0 0
43987 225775 variant_image 56220 0 V 0 D 0 0
43988 225776 variant_image 56221 0 V 0 D 0 0
43989 225777 variant_image 56222 0 V 0 D 0 0
43990 225778 variant_image 56223 0 V 0 D 0 0
43991 225779 variant_image 56224 0 V 0 D 0 0
43992 225780 variant_image 56225 0 V 0 D 0 0
43993 225781 variant_image 56226 0 V 0 D 0 0
43994 225782 variant_image 56227 0 V 0 D 0 0
43995 225783 variant_image 56228 0 V 0 D 0 0
44000 225788 variant_image 56233 0 V 0 D 0 0
44001 225789 variant_image 56234 0 V 0 D 0 0
44002 225791 variant_image 56235 0 V 0 D 0 0
44003 225806 variant_image 56236 0 V 0 D 0 0
44004 225807 variant_image 56237 0 V 0 D 0 0
44005 225808 variant_image 56238 0 V 0 D 0 0
44006 225809 variant_image 56239 0 V 0 D 0 0
44007 225810 variant_image 56240 0 V 0 D 0 0
44008 225811 variant_image 56241 0 V 0 D 0 0
44009 225812 variant_image 56242 0 V 0 D 0 0
44010 225813 variant_image 56243 0 V 0 D 0 0
44011 225814 variant_image 56244 0 V 0 D 0 0
44012 225815 variant_image 56245 0 V 0 D 0 0
44013 225816 variant_image 56246 0 V 0 D 0 0
44014 225817 variant_image 56247 0 V 0 D 0 0
44015 225818 variant_image 56248 0 V 0 D 0 0
44016 225819 variant_image 56249 0 V 0 D 0 0
44017 225820 variant_image 56250 0 V 0 D 0 0
44018 225821 variant_image 56251 0 V 0 D 0 0
44019 225822 variant_image 56252 0 V 0 D 0 0
44020 225823 variant_image 56253 0 V 0 D 0 0
44021 225824 variant_image 56254 0 V 0 D 0 0
44022 225825 variant_image 56255 0 V 0 D 0 0
44023 225826 variant_image 56256 0 V 0 D 0 0
44024 225827 variant_image 56257 0 V 0 D 0 0
44025 225828 variant_image 56258 0 V 0 D 0 0
44026 225829 variant_image 56259 0 V 0 D 0 0
44027 225830 variant_image 56260 0 V 0 D 0 0
44028 225831 variant_image 56261 0 V 0 D 0 0
44029 225832 variant_image 56262 0 V 0 D 0 0
44030 225833 variant_image 56263 0 V 0 D 0 0
59316 236757 variant_image 71549 0 V 0 D 0 0
59317 236758 variant_image 71550 0 V 0 D 0 0
59318 236759 variant_image 71551 0 V 0 D 0 0
59319 236760 variant_image 71552 0 V 0 D 0 0
59320 236761 variant_image 71553 0 V 0 D 0 0
59321 236762 variant_image 71554 0 V 0 D 0 0
59322 236763 variant_image 71555 0 V 0 D 0 0
59323 236764 variant_image 71556 0 V 0 D 0 0
59324 236765 variant_image 71557 0 V 0 D 0 0
59325 236766 variant_image 71558 0 V 0 D 0 0
59326 236767 variant_image 71559 0 V 0 D 0 0
59327 236768 variant_image 71560 0 V 0 D 0 0
59328 236769 variant_image 71561 0 V 0 D 0 0
59329 236770 variant_image 71562 0 V 0 D 0 0
59330 236771 variant_image 71563 0 V 0 D 0 0
59331 236772 variant_image 71564 0 V 0 D 0 0
59332 236773 variant_image 71565 0 V 0 D 0 0
59333 236774 variant_image 71566 0 V 0 D 0 0
59334 236775 variant_image 71567 0 V 0 D 0 0
59335 236776 variant_image 71568 0 V 0 D 0 0
59336 236777 variant_image 71569 0 V 0 D 0 0
59337 236778 variant_image 71570 0 V 0 D 0 0
59338 236779 variant_image 71571 0 V 0 D 0 0
59339 236780 variant_image 71572 0 V 0 D 0 0
59340 236781 variant_image 71573 0 V 0 D 0 0
59345 236786 variant_image 71578 0 V 0 D 0 0
59346 236787 variant_image 71579 0 V 0 D 0 0
59347 236789 variant_image 71580 0 V 0 D 0 0
59851 237104 variant_image 72084 0 V 0 D 0 0
59852 237105 variant_image 72085 0 V 0 D 0 0
59853 237106 variant_image 72086 0 V 0 D 0 0
59854 237107 variant_image 72087 0 V 0 D 0 0
59855 237108 variant_image 72088 0 V 0 D 0 0
59856 237109 variant_image 72089 0 V 0 D 0 0
59907 237160 variant_image 72140 0 V 0 D 0 0
59908 237161 variant_image 72141 0 V 0 D 0 0
71487 241934 variant_image 83720 0 V 0 D 0 0
71488 241935 variant_image 83721 0 V 0 D 0 0
71489 241936 variant_image 83722 0 V 0 D 0 0
71490 241937 variant_image 83723 0 V 0 D 0 0
71491 241938 variant_image 83724 0 V 0 D 0 0
71492 241939 variant_image 83725 0 V 0 D 0 0
71493 241940 variant_image 83726 0 V 0 D 0 0
71494 241941 variant_image 83727 0 V 0 D 0 0
71495 241942 variant_image 83728 0 V 0 D 0 0
71496 241943 variant_image 83729 0 V 0 D 0 0
71497 241944 variant_image 83730 0 V 0 D 0 0
71498 241945 variant_image 83731 0 V 0 D 0 0
71499 241946 variant_image 83732 0 V 0 D 0 0
71500 241947 variant_image 83733 0 V 0 D 0 0
71501 241948 variant_image 83734 0 V 0 D 0 0
71502 241949 variant_image 83735 0 V 0 D 0 0
71503 241950 variant_image 83736 0 V 0 D 0 0
71504 241951 variant_image 83737 0 V 0 D 0 0
71505 241952 variant_image 83738 0 V 0 D 0 0
71506 241953 variant_image 83739 0 V 0 D 0 0
72537 242928 variant_image 84770 0 V 0 D 0 0
72538 242929 variant_image 84771 0 V 0 D 0 0
72539 242930 variant_image 84772 0 V 0 D 0 0
72540 242931 variant_image 84773 0 V 0 D 0 0
72541 242932 variant_image 84774 0 V 0 D 0 0
72542 242933 variant_image 84775 0 V 0 D 0 0
72543 242934 variant_image 84776 0 V 0 D 0 0
72544 242935 variant_image 84777 0 V 0 D 0 0
72545 242936 variant_image 84778 0 V 0 D 0 0
72546 242937 variant_image 84779 0 V 0 D 0 0
72547 242938 variant_image 84780 0 V 0 D 0 0
72548 242939 variant_image 84781 0 V 0 D 0 0
72549 242940 variant_image 84782 0 V 0 D 0 0
72550 242941 variant_image 84783 0 V 0 D 0 0
72551 242942 variant_image 84784 0 V 0 D 0 0
72552 242943 variant_image 84785 0 V 0 D 0 0