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, 
    220212, 
    219067, 
    219068, 
    219069, 
    221140, 
    221141, 
    221142, 
    225255, 
    225245, 
    225246, 
    225247, 
    225266, 
    225256, 
    225257, 
    225258, 
    225277, 
    225267, 
    225268, 
    225269, 
    225335, 
    225305, 
    225306, 
    225307, 
    225308, 
    225309, 
    225310, 
    237186, 
    237187, 
    225311, 
    225331, 
    241954, 
    225312, 
    225313, 
    225314, 
    225315, 
    225316, 
    241955, 
    225317, 
    225318, 
    225319, 
    225320, 
    225321, 
    225322, 
    225323, 
    225324, 
    241956, 
    225325, 
    241957, 
    225326, 
    225327, 
    225333, 
    225328, 
    225329, 
    225330, 
    241958, 
    225366, 
    225336, 
    225337, 
    225338, 
    225339, 
    225340, 
    225341, 
    237188, 
    237189, 
    225342, 
    225362, 
    241959, 
    225343, 
    225344, 
    225345, 
    225346, 
    225347, 
    241960, 
    225348, 
    225349, 
    225350, 
    225351, 
    225352, 
    225353, 
    225354, 
    225355, 
    241961, 
    225356, 
    241962, 
    225357, 
    225358, 
    225364, 
    225359, 
    225360, 
    225361, 
    241963, 
    225700, 
    225702, 
    225703, 
    225704, 
    225705, 
    225706, 
    237792, 
    237786, 
    237787, 
    237788, 
    237789, 
    237790, 
    237791, 
    237823, 
    237793, 
    237794, 
    237795, 
    237796, 
    237797, 
    237798, 
    237824, 
    237825, 
    237799, 
    237819, 
    241964, 
    237800, 
    237801, 
    237802, 
    237803, 
    237804, 
    241965, 
    237805, 
    237806, 
    237807, 
    237808, 
    237809, 
    237810, 
    237811, 
    237812, 
    241966, 
    237813, 
    241967, 
    237814, 
    237815, 
    237821, 
    237816, 
    237817, 
    237818, 
    241968
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00234

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": 178,
          "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,220212,219067,219068,219069,221140,221141,221142,225255,225245,225246,225247,225266,225256,225257,225258,225277,225267,225268,225269,225335,225305,225306,225307,225308,225309,225310,237186,237187,225311,225331,241954,225312,225313,225314,225315,225316,241955,225317,225318,225319,225320,225321,225322,225323,225324,241956,225325,241957,225326,225327,225333,225328,225329,225330,241958,225366,225336,225337,225338,225339,225340,225341,237188,237189,225342,225362,241959,225343,225344,225345,225346,225347,241960,225348,225349,225350,225351,225352,225353,225354,225355,241961,225356,241962,225357,225358,225364,225359,225360,225361,241963,225700,225702,225703,225704,225705,225706,237792,237786,237787,237788,237789,237790,237791,237823,237793,237794,237795,237796,237797,237798,237824,237825,237799,237819,241964,237800,237801,237802,237803,237804,241965,237805,237806,237807,237808,237809,237810,237811,237812,241966,237813,241967,237814,237815,237821,237816,237817,237818,241968)"
        }
      }
    },
    "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
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
37666 219067 variant_image 49899 0 V 0 D 0 0
37667 219068 variant_image 49900 0 V 0 D 0 0
37668 219069 variant_image 49901 0 V 0 D 0 0
39609 221141 variant_image 51842 0 V 0 D 0 0
39610 221142 variant_image 51843 0 V 0 D 0 0
43493 225245 variant_image 55726 0 V 0 D 0 0
43494 225246 variant_image 55727 0 V 0 D 0 0
43495 225247 variant_image 55728 0 V 0 D 0 0
43503 225256 variant_image 55736 0 V 0 D 0 0
43504 225257 variant_image 55737 0 V 0 D 0 0
43505 225258 variant_image 55738 0 V 0 D 0 0
43513 225267 variant_image 55746 0 V 0 D 0 0
43514 225268 variant_image 55747 0 V 0 D 0 0
43515 225269 variant_image 55748 0 V 0 D 0 0
43549 225305 variant_image 55782 0 V 0 D 0 0
43550 225306 variant_image 55783 0 V 0 D 0 0
43551 225307 variant_image 55784 0 V 0 D 0 0
43552 225308 variant_image 55785 0 V 0 D 0 0
43553 225309 variant_image 55786 0 V 0 D 0 0
43554 225310 variant_image 55787 0 V 0 D 0 0
43555 225311 variant_image 55788 0 V 0 D 0 0
43556 225312 variant_image 55789 0 V 0 D 0 0
43557 225313 variant_image 55790 0 V 0 D 0 0
43558 225314 variant_image 55791 0 V 0 D 0 0
43559 225315 variant_image 55792 0 V 0 D 0 0
43560 225316 variant_image 55793 0 V 0 D 0 0
43561 225317 variant_image 55794 0 V 0 D 0 0
43562 225318 variant_image 55795 0 V 0 D 0 0
43563 225319 variant_image 55796 0 V 0 D 0 0
43564 225320 variant_image 55797 0 V 0 D 0 0
43565 225321 variant_image 55798 0 V 0 D 0 0
43566 225322 variant_image 55799 0 V 0 D 0 0
43567 225323 variant_image 55800 0 V 0 D 0 0
43568 225324 variant_image 55801 0 V 0 D 0 0
43569 225325 variant_image 55802 0 V 0 D 0 0
43570 225326 variant_image 55803 0 V 0 D 0 0
43571 225327 variant_image 55804 0 V 0 D 0 0
43572 225328 variant_image 55805 0 V 0 D 0 0
43573 225329 variant_image 55806 0 V 0 D 0 0
43574 225330 variant_image 55807 0 V 0 D 0 0
43575 225331 variant_image 55808 0 V 0 D 0 0
43577 225333 variant_image 55810 0 V 0 D 0 0
43579 225336 variant_image 55812 0 V 0 D 0 0
43580 225337 variant_image 55813 0 V 0 D 0 0
43581 225338 variant_image 55814 0 V 0 D 0 0
43582 225339 variant_image 55815 0 V 0 D 0 0
43583 225340 variant_image 55816 0 V 0 D 0 0
43584 225341 variant_image 55817 0 V 0 D 0 0
43585 225342 variant_image 55818 0 V 0 D 0 0
43586 225343 variant_image 55819 0 V 0 D 0 0
43587 225344 variant_image 55820 0 V 0 D 0 0
43588 225345 variant_image 55821 0 V 0 D 0 0
43589 225346 variant_image 55822 0 V 0 D 0 0
43590 225347 variant_image 55823 0 V 0 D 0 0
43591 225348 variant_image 55824 0 V 0 D 0 0
43592 225349 variant_image 55825 0 V 0 D 0 0
43593 225350 variant_image 55826 0 V 0 D 0 0
43594 225351 variant_image 55827 0 V 0 D 0 0
43595 225352 variant_image 55828 0 V 0 D 0 0
43596 225353 variant_image 55829 0 V 0 D 0 0
43597 225354 variant_image 55830 0 V 0 D 0 0
43598 225355 variant_image 55831 0 V 0 D 0 0
43599 225356 variant_image 55832 0 V 0 D 0 0
43600 225357 variant_image 55833 0 V 0 D 0 0
43601 225358 variant_image 55834 0 V 0 D 0 0
43602 225359 variant_image 55835 0 V 0 D 0 0
43603 225360 variant_image 55836 0 V 0 D 0 0
43604 225361 variant_image 55837 0 V 0 D 0 0
43605 225362 variant_image 55838 0 V 0 D 0 0
43607 225364 variant_image 55840 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
59933 237186 variant_image 72166 0 V 0 D 0 0
59934 237187 variant_image 72167 0 V 0 D 0 0
59935 237188 variant_image 72168 0 V 0 D 0 0
59936 237189 variant_image 72169 0 V 0 D 0 0
60955 237786 variant_image 73188 0 V 0 D 0 0
60956 237787 variant_image 73189 0 V 0 D 0 0
60957 237788 variant_image 73190 0 V 0 D 0 0
60958 237789 variant_image 73191 0 V 0 D 0 0
60959 237790 variant_image 73192 0 V 0 D 0 0
60960 237791 variant_image 73193 0 V 0 D 0 0
60961 237793 variant_image 73194 0 V 0 D 0 0
60962 237794 variant_image 73195 0 V 0 D 0 0
60963 237795 variant_image 73196 0 V 0 D 0 0
60964 237796 variant_image 73197 0 V 0 D 0 0
60965 237797 variant_image 73198 0 V 0 D 0 0
60966 237798 variant_image 73199 0 V 0 D 0 0
60967 237799 variant_image 73200 0 V 0 D 0 0
60968 237800 variant_image 73201 0 V 0 D 0 0
60969 237801 variant_image 73202 0 V 0 D 0 0
60970 237802 variant_image 73203 0 V 0 D 0 0
60971 237803 variant_image 73204 0 V 0 D 0 0
60972 237804 variant_image 73205 0 V 0 D 0 0
60973 237805 variant_image 73206 0 V 0 D 0 0
60974 237806 variant_image 73207 0 V 0 D 0 0
60975 237807 variant_image 73208 0 V 0 D 0 0
60976 237808 variant_image 73209 0 V 0 D 0 0
60977 237809 variant_image 73210 0 V 0 D 0 0
60978 237810 variant_image 73211 0 V 0 D 0 0
60979 237811 variant_image 73212 0 V 0 D 0 0
60980 237812 variant_image 73213 0 V 0 D 0 0
60981 237813 variant_image 73214 0 V 0 D 0 0
60982 237814 variant_image 73215 0 V 0 D 0 0
60983 237815 variant_image 73216 0 V 0 D 0 0
60984 237816 variant_image 73217 0 V 0 D 0 0
60985 237817 variant_image 73218 0 V 0 D 0 0
60986 237818 variant_image 73219 0 V 0 D 0 0
60987 237819 variant_image 73220 0 V 0 D 0 0
60989 237821 variant_image 73222 0 V 0 D 0 0
60991 237824 variant_image 73224 0 V 0 D 0 0
60992 237825 variant_image 73225 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
71507 241954 variant_image 83740 0 V 0 D 0 0
71508 241955 variant_image 83741 0 V 0 D 0 0
71509 241956 variant_image 83742 0 V 0 D 0 0
71510 241957 variant_image 83743 0 V 0 D 0 0
71511 241958 variant_image 83744 0 V 0 D 0 0
71512 241959 variant_image 83745 0 V 0 D 0 0
71513 241960 variant_image 83746 0 V 0 D 0 0
71514 241961 variant_image 83747 0 V 0 D 0 0
71515 241962 variant_image 83748 0 V 0 D 0 0
71516 241963 variant_image 83749 0 V 0 D 0 0
71517 241964 variant_image 83750 0 V 0 D 0 0
71518 241965 variant_image 83751 0 V 0 D 0 0
71519 241966 variant_image 83752 0 V 0 D 0 0
71520 241967 variant_image 83753 0 V 0 D 0 0
71521 241968 variant_image 83754 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