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 (
    94857, 94814, 95739, 95696, 95695, 89230, 
    95546, 95200, 94865, 94683, 93093, 
    92916, 95501, 95500, 95499, 95498, 
    95497, 95496, 95495, 95494
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00093

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-314-Artwork.jpg 3000 3000 95780 92916 product 99303 M 0 99303
0 HHF012.jpg 3000 3000 95960 93093 product 99483 M 0 99483
0 5054285794364.jpg 1000 1000 97570 94683 product 101093 M 0 101093
0 5054285794371.jpg 1000 1000 97704 94814 product 101227 M 0 101227
0 5054285820636.jpg 1000 1000 97749 94857 product 101272 M 0 101272
0 5054285822760.jpg 1000 1000 97757 94865 product 101280 M 0 101280
0 5054285852200.jpg 1000 1000 98094 95200 product 101617 M 0 101617
0 Zero_Input.jpg 1400 1400 98416 95494 product 101939 M 0 101939
0 Kauz_BB021.jpg 1750 1750 98417 95495 product 101940 M 0 101940
0 Dan_Dyson_kk005.jpg 1750 1750 98418 95496 product 101941 M 0 101941
0 180174876_3889941051088315_8120995709787704753_n.jpg 1399 1399 98420 95498 product 101943 M 0 101943
0 ESP_Turcois_x8fu-0a.png 400 400 98421 95499 product 101944 M 0 101944
0 VRF008_Cover_Viral_Meat_Paul_Reeves.png 800 800 98422 95497 product 101945 M 0 101945
0 TMP0174.png 2160 2160 98423 95500 product 101946 M 0 101946
0 TMP0175.png 2160 2160 98424 95501 product 101947 M 0 101947
0 Mine.png 2000 2000 98468 95546 product 101991 M 0 101991
0 181580024_474915257079898_4544603277534475546_n.jpg 1080 1077 98617 95695 product 102140 M 0 102140
0 181362391_366922594702041_5544441197660439345_n.jpg 1080 1077 98618 95696 product 102141 M 0 102141
0 St12_Hardware.jpg 1181 1181 98661 95739 product 102184 M 0 102184
0 RRR_sleaveV2_019.jpg 1500 1500 98723 89230 product 102246 M 0 102246