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 (
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    240655, 
    240817, 
    240652, 
    240654, 
    240660, 
    240656, 
    240657, 
    240658, 
    240659, 
    240844, 
    240818, 
    240819, 
    240820, 
    240821, 
    240843, 
    240836, 
    240845, 
    240846, 
    240822, 
    240848, 
    240823, 
    240824, 
    240825, 
    240826, 
    240827, 
    240849, 
    240828, 
    240829, 
    240830, 
    240831, 
    240832, 
    240833, 
    240834, 
    240835, 
    240850, 
    240851, 
    240837, 
    240838, 
    240839, 
    240840, 
    240841, 
    240842, 
    240853, 
    242952, 
    242953, 
    242954, 
    242955, 
    242956, 
    242957, 
    242958, 
    242959, 
    242960, 
    240880, 
    240856, 
    240854, 
    240855, 
    240857, 
    240879, 
    240872, 
    240881, 
    240882, 
    240858, 
    240884, 
    240859, 
    240860, 
    240861, 
    240862, 
    240863, 
    240885, 
    240864, 
    240865, 
    240866, 
    240867, 
    240868, 
    240869, 
    240870, 
    240871, 
    240886, 
    240887, 
    240873, 
    240874, 
    240875, 
    240876, 
    240877, 
    240878, 
    240889, 
    242961, 
    242962, 
    242963, 
    242964, 
    242965, 
    242966, 
    242967, 
    242968, 
    242969, 
    240891, 
    240890, 
    240892, 
    244232, 
    244231, 
    244207, 
    244208, 
    244206, 
    244209, 
    244210, 
    244211, 
    244235, 
    244236, 
    244212, 
    244237, 
    244213, 
    244214, 
    244215, 
    244216, 
    244217, 
    244238, 
    244218, 
    244219, 
    244220, 
    244221, 
    244222, 
    244223, 
    244224, 
    244225, 
    244239, 
    244226, 
    244240, 
    244227, 
    244228, 
    244229, 
    244230, 
    244241, 
    244268, 
    244267, 
    244243, 
    244244, 
    244242, 
    244245, 
    244246, 
    244247, 
    244271, 
    244272, 
    244248, 
    244273, 
    244249, 
    244250, 
    244251, 
    244252, 
    244253, 
    244274, 
    244254, 
    244255, 
    244256, 
    244257, 
    244258, 
    244259, 
    244260, 
    244261, 
    244275, 
    244262, 
    244276, 
    244263, 
    244264, 
    244265, 
    244266, 
    244277
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00280

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": 171,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (223755,223756,223757,223758,223759,240655,240817,240652,240654,240660,240656,240657,240658,240659,240844,240818,240819,240820,240821,240843,240836,240845,240846,240822,240848,240823,240824,240825,240826,240827,240849,240828,240829,240830,240831,240832,240833,240834,240835,240850,240851,240837,240838,240839,240840,240841,240842,240853,242952,242953,242954,242955,242956,242957,242958,242959,242960,240880,240856,240854,240855,240857,240879,240872,240881,240882,240858,240884,240859,240860,240861,240862,240863,240885,240864,240865,240866,240867,240868,240869,240870,240871,240886,240887,240873,240874,240875,240876,240877,240878,240889,242961,242962,242963,242964,242965,242966,242967,242968,242969,240891,240890,240892,244232,244231,244207,244208,244206,244209,244210,244211,244235,244236,244212,244237,244213,244214,244215,244216,244217,244238,244218,244219,244220,244221,244222,244223,244224,244225,244239,244226,244240,244227,244228,244229,244230,244241,244268,244267,244243,244244,244242,244245,244246,244247,244271,244272,244248,244273,244249,244250,244251,244252,244253,244274,244254,244255,244256,244257,244258,244259,244260,244261,244275,244262,244276,244263,244264,244265,244266,244277)"
        }
      }
    },
    "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
70041 240656 variant_image 82274 0 V 0 D 0 0
70042 240657 variant_image 82275 0 V 0 D 0 0
70043 240658 variant_image 82276 0 V 0 D 0 0
70044 240659 variant_image 82277 0 V 0 D 0 0
70322 240818 variant_image 82555 0 V 0 D 0 0
70323 240819 variant_image 82556 0 V 0 D 0 0
70324 240820 variant_image 82557 0 V 0 D 0 0
70325 240821 variant_image 82558 0 V 0 D 0 0
70326 240822 variant_image 82559 0 V 0 D 0 0
70327 240823 variant_image 82560 0 V 0 D 0 0
70328 240824 variant_image 82561 0 V 0 D 0 0
70329 240825 variant_image 82562 0 V 0 D 0 0
70330 240826 variant_image 82563 0 V 0 D 0 0
70331 240827 variant_image 82564 0 V 0 D 0 0
70332 240828 variant_image 82565 0 V 0 D 0 0
70333 240829 variant_image 82566 0 V 0 D 0 0
70334 240830 variant_image 82567 0 V 0 D 0 0
70335 240831 variant_image 82568 0 V 0 D 0 0
70336 240832 variant_image 82569 0 V 0 D 0 0
70337 240833 variant_image 82570 0 V 0 D 0 0
70338 240834 variant_image 82571 0 V 0 D 0 0
70339 240835 variant_image 82572 0 V 0 D 0 0
70340 240836 variant_image 82573 0 V 0 D 0 0
70341 240837 variant_image 82574 0 V 0 D 0 0
70342 240838 variant_image 82575 0 V 0 D 0 0
70343 240839 variant_image 82576 0 V 0 D 0 0
70344 240840 variant_image 82577 0 V 0 D 0 0
70345 240841 variant_image 82578 0 V 0 D 0 0
70346 240842 variant_image 82579 0 V 0 D 0 0
70347 240843 variant_image 82580 0 V 0 D 0 0
70348 240845 variant_image 82581 0 V 0 D 0 0
70349 240846 variant_image 82582 0 V 0 D 0 0
70352 240854 variant_image 82585 0 V 0 D 0 0
70353 240855 variant_image 82586 0 V 0 D 0 0
70354 240856 variant_image 82587 0 V 0 D 0 0
70355 240857 variant_image 82588 0 V 0 D 0 0
70356 240858 variant_image 82589 0 V 0 D 0 0
70357 240859 variant_image 82590 0 V 0 D 0 0
70358 240860 variant_image 82591 0 V 0 D 0 0
70359 240861 variant_image 82592 0 V 0 D 0 0
70360 240862 variant_image 82593 0 V 0 D 0 0
70361 240863 variant_image 82594 0 V 0 D 0 0
70362 240864 variant_image 82595 0 V 0 D 0 0
70363 240865 variant_image 82596 0 V 0 D 0 0
70364 240866 variant_image 82597 0 V 0 D 0 0
70365 240867 variant_image 82598 0 V 0 D 0 0
70366 240868 variant_image 82599 0 V 0 D 0 0
70367 240869 variant_image 82600 0 V 0 D 0 0
70368 240870 variant_image 82601 0 V 0 D 0 0
70369 240871 variant_image 82602 0 V 0 D 0 0
70370 240872 variant_image 82603 0 V 0 D 0 0
70371 240873 variant_image 82604 0 V 0 D 0 0
70372 240874 variant_image 82605 0 V 0 D 0 0
70373 240875 variant_image 82606 0 V 0 D 0 0
70374 240876 variant_image 82607 0 V 0 D 0 0
70375 240877 variant_image 82608 0 V 0 D 0 0
70376 240878 variant_image 82609 0 V 0 D 0 0
70377 240879 variant_image 82610 0 V 0 D 0 0
70378 240881 variant_image 82611 0 V 0 D 0 0
70379 240882 variant_image 82612 0 V 0 D 0 0
72585 242952 variant_image 84818 0 V 0 D 0 0
72586 242953 variant_image 84819 0 V 0 D 0 0
72587 242954 variant_image 84820 0 V 0 D 0 0
72588 242955 variant_image 84821 0 V 0 D 0 0
72589 240848 variant_image 84822 0 V 0 D 0 0
72590 240849 variant_image 84823 0 V 0 D 0 0
72591 240850 variant_image 84824 0 V 0 D 0 0
72592 240851 variant_image 84825 0 V 0 D 0 0
72593 240853 variant_image 84826 0 V 0 D 0 0
72594 242956 variant_image 84827 0 V 0 D 0 0
72595 242957 variant_image 84828 0 V 0 D 0 0
72596 242958 variant_image 84829 0 V 0 D 0 0
72597 242959 variant_image 84830 0 V 0 D 0 0
72598 242960 variant_image 84831 0 V 0 D 0 0
72599 240884 variant_image 84832 0 V 0 D 0 0
72600 240885 variant_image 84833 0 V 0 D 0 0
72601 240886 variant_image 84834 0 V 0 D 0 0
72602 240887 variant_image 84835 0 V 0 D 0 0
72603 240889 variant_image 84836 0 V 0 D 0 0
72604 242961 variant_image 84837 0 V 0 D 0 0
72605 242962 variant_image 84838 0 V 0 D 0 0
72606 242963 variant_image 84839 0 V 0 D 0 0
72607 242964 variant_image 84840 0 V 0 D 0 0
72608 242965 variant_image 84841 0 V 0 D 0 0
72609 242966 variant_image 84842 0 V 0 D 0 0
72610 242967 variant_image 84843 0 V 0 D 0 0
72611 242968 variant_image 84844 0 V 0 D 0 0
72612 242969 variant_image 84845 0 V 0 D 0 0
73929 240817 variant_image 86162 0 V 0 D 0 0
73930 240652 variant_image 86163 0 V 0 D 0 0
73931 240654 variant_image 86164 0 V 0 D 0 0
73933 244206 variant_image 86166 0 V 0 D 0 0
73934 244207 variant_image 86167 0 V 0 D 0 0
73935 244208 variant_image 86168 0 V 0 D 0 0
73936 244209 variant_image 86169 0 V 0 D 0 0
73937 244210 variant_image 86170 0 V 0 D 0 0
73938 244211 variant_image 86171 0 V 0 D 0 0
73939 244212 variant_image 86172 0 V 0 D 0 0
73940 244213 variant_image 86173 0 V 0 D 0 0
73941 244214 variant_image 86174 0 V 0 D 0 0
73942 244215 variant_image 86175 0 V 0 D 0 0
73943 244216 variant_image 86176 0 V 0 D 0 0
73944 244217 variant_image 86177 0 V 0 D 0 0
73945 244218 variant_image 86178 0 V 0 D 0 0
73946 244219 variant_image 86179 0 V 0 D 0 0
73947 244220 variant_image 86180 0 V 0 D 0 0
73948 244221 variant_image 86181 0 V 0 D 0 0
73949 244222 variant_image 86182 0 V 0 D 0 0
73950 244223 variant_image 86183 0 V 0 D 0 0
73951 244224 variant_image 86184 0 V 0 D 0 0
73952 244225 variant_image 86185 0 V 0 D 0 0
73953 244226 variant_image 86186 0 V 0 D 0 0
73954 244227 variant_image 86187 0 V 0 D 0 0
73955 244228 variant_image 86188 0 V 0 D 0 0
73956 244229 variant_image 86189 0 V 0 D 0 0
73957 244230 variant_image 86190 0 V 0 D 0 0
73958 244231 variant_image 86191 0 V 0 D 0 0
73961 244235 variant_image 86194 0 V 0 D 0 0
73962 244236 variant_image 86195 0 V 0 D 0 0
73963 244237 variant_image 86196 0 V 0 D 0 0
73964 244238 variant_image 86197 0 V 0 D 0 0
73965 244239 variant_image 86198 0 V 0 D 0 0
73966 244240 variant_image 86199 0 V 0 D 0 0
73967 244241 variant_image 86200 0 V 0 D 0 0
73968 244242 variant_image 86201 0 V 0 D 0 0
73969 244243 variant_image 86202 0 V 0 D 0 0
73970 244244 variant_image 86203 0 V 0 D 0 0
73971 244245 variant_image 86204 0 V 0 D 0 0
73972 244246 variant_image 86205 0 V 0 D 0 0
73973 244247 variant_image 86206 0 V 0 D 0 0
73974 244248 variant_image 86207 0 V 0 D 0 0
73975 244249 variant_image 86208 0 V 0 D 0 0
73976 244250 variant_image 86209 0 V 0 D 0 0
73977 244251 variant_image 86210 0 V 0 D 0 0
73978 244252 variant_image 86211 0 V 0 D 0 0
73979 244253 variant_image 86212 0 V 0 D 0 0
73980 244254 variant_image 86213 0 V 0 D 0 0
73981 244255 variant_image 86214 0 V 0 D 0 0
73982 244256 variant_image 86215 0 V 0 D 0 0
73983 244257 variant_image 86216 0 V 0 D 0 0
73984 244258 variant_image 86217 0 V 0 D 0 0
73985 244259 variant_image 86218 0 V 0 D 0 0
73986 244260 variant_image 86219 0 V 0 D 0 0
73987 244261 variant_image 86220 0 V 0 D 0 0
73988 244262 variant_image 86221 0 V 0 D 0 0
73989 244263 variant_image 86222 0 V 0 D 0 0
73990 244264 variant_image 86223 0 V 0 D 0 0
73991 244265 variant_image 86224 0 V 0 D 0 0
73992 244266 variant_image 86225 0 V 0 D 0 0
73993 244267 variant_image 86226 0 V 0 D 0 0
73996 244271 variant_image 86229 0 V 0 D 0 0
73997 244272 variant_image 86230 0 V 0 D 0 0
73998 244273 variant_image 86231 0 V 0 D 0 0
73999 244274 variant_image 86232 0 V 0 D 0 0
74000 244275 variant_image 86233 0 V 0 D 0 0
74001 244276 variant_image 86234 0 V 0 D 0 0
74002 244277 variant_image 86235 0 V 0 D 0 0