SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  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 = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    99381, 99279, 92940, 99916, 99866, 99806, 
    99805, 99804, 99790, 99789, 99753, 
    99751, 99439, 99434, 99429, 99278, 
    99257, 99219, 99372, 99360
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00054

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_images_links range object_id object_id 81 20 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 4 toolboxdigitalshop_dev.cscart_images_links.detailed_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where

Result

image_id image_path image_x image_y pair_id object_id object_type detailed_id type position alt images_image_id
0 Vicious-Circle-Recordings-339-Artwork.jpg 3000 3000 95804 92940 product 99327 M 0 99327
0 jud.png 2560 2560 102260 99219 product 105783 M 0 105783
0 FT002_F-Trax_Outspoken_Outsider_Artwork.png 3000 3000 102297 99257 product 105820 M 0 105820
0 TB20R012.jpg 3239 3239 102321 99278 product 105844 M 0 105844
0 TB20R013.jpg 3239 3239 102322 99279 product 105845 M 0 105845
0 Screenshot_20210928-023403_Instagram.jpg 720 712 102402 99360 product 105925 M 0 105925
0 002_-_Danny_Gilligan___James_Nardi.jpg 3000 3000 102414 99372 product 105937 M 0 105937
0 5054286198079.jpg 1000 1000 102423 99381 product 105946 M 0 105946
0 Fireball_Recordings_Artwork_-_FBR344.jpg 3000 3000 102475 99434 product 105998 M 0 105998
0 VR010_Cover_AtNight_Slenderman_RossFarley.png 800 800 102481 99439 product 106004 M 0 106004
0 Frantic_sleeve_FD059-Dan-Carter---Narcotic-Bass_1MB.jpg 3000 3000 102516 99429 product 106039 M 0 106039
0 TBHH037a_Kauz_-_Northern_Exposure_Artwork-min.jpg 3000 3000 102819 99751 product 106342 M 0 106342
0 NITROX122_-_Vespa_-_Valex_-_Waltered_-_Nitrox.jpg 3600 3600 102821 99753 product 106344 M 0 106344
0 PicsArt_09-24-04.54.56.jpg 1080 1080 102858 99789 product 106381 M 0 106381
0 PicsArt_09-24-04.56.44.jpg 1080 1080 102859 99790 product 106382 M 0 106382
0 FSD002_Ben_Warren_-_Let's_Do_It.png 1080 1080 102874 99804 product 106397 M 0 106397
0 IA022.jpg 1600 1600 102875 99805 product 106398 M 0 106398
0 9736f8399f8b45cd97ee7f6b58a6e8b9.jpg 451 450 102876 99806 product 106399 M 0 106399
0 20211018_0754220.03901211901548984.png 2000 2000 102936 99866 product 106459 M 0 106459
0 WLHH031_Rick_James_-_Fab.jpg 3600 3600 102986 99916 product 106509 M 0 106509