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 (
    74996, 75157, 74620, 74619, 74618, 74617, 
    74616, 74615, 74614, 74613, 74612, 
    74611, 74870, 74993, 74918, 74515, 
    74513, 74512, 74898, 74465
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00055

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 5054284129297_w9be-ba.jpg 1000 1000 77279 74465 product 80802 M 0 80802
0 5054284223681.jpg 1000 1000 77326 74512 product 80849 M 0 80849
0 5054284234786.jpg 1000 1000 77327 74513 product 80850 M 0 80850
0 5054284214603.jpg 1000 1000 77329 74515 product 80852 M 0 80852
0 5054284200262.jpg 1000 1000 77427 74611 product 80950 M 0 80950
0 5054284200262_tz7s-r8.jpg 1000 1000 77428 74612 product 80951 M 0 80951
0 5054284200262_t616-8p.jpg 1000 1000 77429 74613 product 80952 M 0 80952
0 5054284200262_sep3-7e.jpg 1000 1000 77430 74614 product 80953 M 0 80953
0 5054284200262_v49s-zy.jpg 1000 1000 77431 74615 product 80954 M 0 80954
0 5054284200262_z2lx-uc.jpg 1000 1000 77432 74616 product 80955 M 0 80955
0 5054284200262_eocm-g3.jpg 1000 1000 77433 74617 product 80956 M 0 80956
0 5054284200262_u9av-gi.jpg 1000 1000 77434 74618 product 80957 M 0 80957
0 5054284200262_5yb3-2c.jpg 1000 1000 77435 74619 product 80958 M 0 80958
0 5054284200262_ou0s-h8.jpg 1000 1000 77436 74620 product 80959 M 0 80959
0 5054284265919.jpg 1000 1000 77689 74870 product 81212 M 0 81212
0 5054284260839.jpg 1000 1000 77717 74898 product 81240 M 0 81240
0 5054284267555.jpg 1000 1000 77737 74918 product 81260 M 0 81260
0 5054284280400.jpg 1000 1000 77815 74993 product 81338 M 0 81338
0 5054284265933.jpg 1000 1000 77818 74996 product 81341 M 0 81341
0 5054284283920.jpg 1000 1000 77981 75157 product 81504 M 0 81504