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 (
    75435, 75434, 75344, 74998, 74784, 75253, 
    75252, 75251, 75250, 75249, 75248, 
    75247, 75246, 75245, 75244, 75243, 
    75242, 74751, 74748, 74747
  ) 
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 5054284223711.jpg 1000 1000 77564 74747 product 81087 M 0 81087
0 5054284223711_ulgz-78.jpg 1000 1000 77565 74748 product 81088 M 0 81088
0 5054284223711_gzyi-bg.jpg 1000 1000 77568 74751 product 81091 M 0 81091
0 5054284241708.jpg 1000 1000 77602 74784 product 81125 M 0 81125
0 5054284272948.jpg 1000 1000 77820 74998 product 81343 M 0 81343
0 5054284292151.jpg 1000 1000 78076 75242 product 81599 M 0 81599
0 5054284292151_0hil-03.jpg 1000 1000 78077 75243 product 81600 M 0 81600
0 5054284292151_ir43-as.jpg 1000 1000 78078 75244 product 81601 M 0 81601
0 5054284292151_ynsi-i1.jpg 1000 1000 78079 75245 product 81602 M 0 81602
0 5054284292151_m5cj-gl.jpg 1000 1000 78080 75246 product 81603 M 0 81603
0 5054284292151_f3ce-61.jpg 1000 1000 78081 75247 product 81604 M 0 81604
0 5054284292151_j7j1-sj.jpg 1000 1000 78082 75248 product 81605 M 0 81605
0 5054284292151_5bba-el.jpg 1000 1000 78083 75249 product 81606 M 0 81606
0 5054284292151_2d8v-vr.jpg 1000 1000 78084 75250 product 81607 M 0 81607
0 5054284292151_whw9-1d.jpg 1000 1000 78085 75251 product 81608 M 0 81608
0 5054284292151_ugg7-un.jpg 1000 1000 78086 75252 product 81609 M 0 81609
0 5054284292151_8eur-gn.jpg 1000 1000 78087 75253 product 81610 M 0 81610
0 5054284295299.jpg 1000 1000 78178 75344 product 81701 M 0 81701
0 5054284303833.jpg 1000 1000 78266 75434 product 81789 M 0 81789
0 5054284303833_ihvl-v6.jpg 1000 1000 78267 75435 product 81790 M 0 81790