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 (
    96060, 95699, 95231, 93055, 89231, 96061, 
    95337, 92918, 96004, 96003, 96002, 
    95999, 95972, 95837, 95802, 95740, 
    95700, 95697, 95062, 95040
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00068

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-316-Artwork.jpg 3000 3000 95782 92918 product 99305 M 0 99305
0 Vicious-Circle-Recordings-317-Artwork---UPDATED.jpg 3000 3000 95922 93055 product 99445 M 0 99445
0 5054285794388.jpg 1000 1000 97932 95040 product 101455 M 0 101455
0 5054285820780.jpg 1000 1000 97954 95062 product 101477 M 0 101477
0 5054285794395.jpg 1000 1000 98127 95231 product 101650 M 0 101650
0 5054285869901.jpg 1000 1000 98233 95337 product 101756 M 0 101756
0 UBT050_copy_3000x3000.jpg 3000 3000 98619 95697 product 102142 M 0 102142
0 5054285890653.jpg 1000 1000 98621 95699 product 102144 M 0 102144
0 TTLFD006_J.Bryant_v_Baseglitz-Viral_Rhythm-01_-_Artwork.png 1080 1080 98622 95700 product 102145 M 0 102145
0 EM002_ARTWORK_TOOLBOX.png 500 500 98663 95740 product 102186 M 0 102186
0 PicsArt_05-07-01.27.09.jpg 1200 1200 98726 95802 product 102249 M 0 102249
0 You_broke_me.jpg 1080 1080 98761 95837 product 102284 M 0 102284
0 RRR_sleaveV2_020.jpg 1500 1500 98851 89231 product 102374 M 0 102374
0 NITROX121_-_Dave_Owens_-_Valex_-_Put_It_On_Me_-_Nitrox.jpg 3600 3600 98945 95972 product 102468 M 0 102468
0 Blinding.jpg 1400 1400 98972 95999 product 102495 M 0 102495
0 bdr005.jpg 1447 1447 98975 96002 product 102498 M 0 102498
0 FR130_-_Random_But_Raw___Sinobe_-_Everyone_Wants.jpg 2000 2000 98977 96003 product 102500 M 0 102500
0 FR131_-_Random_But_Raw___Sinobe_-_For_A_Kick.jpg 2000 2000 98978 96004 product 102501 M 0 102501
0 received_1914850041997691.jpeg 2048 2048 99034 96060 product 102557 M 0 102557
0 mo3.png 2000 2000 99060 96061 product 102583 M 0 102583