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 (
    95010, 95009, 93344, 95875, 95866, 95836, 
    95164, 92917, 95835, 95801, 95800, 
    95852, 95744, 95743, 95742, 95741, 
    95701, 95547, 95538, 95302
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00082

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-315-Artwork.jpg 3000 3000 95781 92917 product 99304 M 0 99304
0 Frantic_sleeve_tFrantic_sleeve_J2S-_-James-Nardi---Tough-Business-FD048_1MB.jpg 3000 3000 96214 93344 product 99737 M 0 99737
0 5054285492710.jpg 1000 1000 97901 95009 product 101424 M 0 101424
0 5054285492710_dgpd-qp.jpg 1000 1000 97902 95010 product 101425 M 0 101425
0 5054285852385.jpg 1000 1000 98058 95164 product 101581 M 0 101581
0 TBR212.jpeg 1440 1440 98198 95302 product 101721 M 0 101721
0 WLHH027_Andy_Naylor_-_I_gotta_have_4n5o-yz.jpg 3600 3600 98460 95538 product 101983 M 0 101983
0 PicsArt_05-01-08.02.27.jpg 1163 1080 98469 95547 product 101992 M 0 101992
0 02_HELIX_cover_HLXR070__resized_.jpg 1400 1400 98623 95701 product 102146 M 0 102146
0 TRI005_-_TriBeaut_-_Love_Music.jpg 3000 3000 98664 95741 product 102187 M 0 102187
0 23.png 1080 1080 98665 95742 product 102188 M 0 102188
0 22.png 1080 1080 98666 95743 product 102189 M 0 102189
0 21.png 1080 1080 98667 95744 product 102190 M 0 102190
0 IA013_LANCE.jpg 1600 1600 98724 95800 product 102247 M 0 102247
0 IA013_Tara_N.jpg 1600 1600 98725 95801 product 102248 M 0 102248
0 Tara_Evac.jpg 1750 1750 98759 95835 product 102282 M 0 102282
0 Worth_It.jpg 1080 1080 98760 95836 product 102283 M 0 102283
0 VR008_Cover_Make_it_Count_RossFarley_Slenderman.png 800 800 98776 95852 product 102299 M 0 102299
0 Im_In.png 2000 2000 98790 95866 product 102313 M 0 102313
0 RRY_sleaveV1_001.jpg 1500 1500 98844 95875 product 102367 M 0 102367