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 (
    95338, 95301, 95193, 95192, 94875, 94822, 
    94657, 94656, 93317, 95297, 95296, 
    94543, 94800, 95005, 92915, 95267, 
    95266, 95265, 95263, 95257
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00066

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-313-Artwork.jpg 3000 3000 95779 92915 product 99302 M 0 99302
0 Frantic_sleeve_J2S---Rave-Day--FD047_1MB.jpg 3000 3000 96186 93317 product 99709 M 0 99709
0 5054285769102.jpg 1000 1000 97430 94543 product 100953 M 0 100953
0 5054285770627.jpg 1000 1000 97544 94656 product 101067 M 0 101067
0 5054285770627_lavr-ft.jpg 1000 1000 97545 94657 product 101068 M 0 101068
0 039.jpg 1000 1000 97688 94800 product 101211 M 0 101211
0 Boris_The_Noss_Dream_The_Dreamvv.jpg 3000 3000 97713 94822 product 101236 M 0 101236
0 5054285826485.jpg 1000 1000 97767 94875 product 101290 M 0 101290
0 Artwork_-_Josh_B_V_Insanity_-_Little_Teef.jpg 1080 1080 97897 95005 product 101420 M 0 101420
0 5054285797112.jpg 1000 1000 98086 95192 product 101609 M 0 101609
0 5054285797112_qq79-t7.jpg 1000 1000 98087 95193 product 101610 M 0 101610
0 FR129_-_Karl_Davies___Random_But_Raw_-_Test_Your_Might.jpg 2000 2000 98158 95263 product 101681 M 0 101681
0 VR007_Cover_The_Light_RossFarley_Slenderman.png 800 800 98159 95265 product 101682 M 0 101682
0 VRF007_Cover_The_Dark_Ross_Farley.png 800 800 98160 95266 product 101683 M 0 101683
0 Toadz020.jpg 1750 1750 98162 95267 product 101685 M 0 101685
0 JAM038_David_Morrish_-_Make_It_Home.jpg 1400 1400 98163 95257 product 101686 M 0 101686
0 Deliver-Body_Rockin'.png 2000 2000 98192 95296 product 101715 M 0 101715
0 Deliver-Body_Rockin'_adrp-tb.png 2000 2000 98193 95297 product 101716 M 0 101716
0 TTLFD006-The_Don_Work_less_PNG-01.png 1080 1080 98234 95338 product 101757 M 0 101757
0 013.jpg 2000 2000 100167 95301 product 103690 M 0 103690