SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  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 = 'de' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    504, 3245, 576, 575, 505, 574, 572, 577, 
    9861, 10501
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00089

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 10 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.detailed_id 1 Using where
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 107 mahm3t_cs443.cscart_images.image_id,const,const 1 Using where

Result

pair_id object_id object_type image_id detailed_id type position emo_md5 image_path alt image_x image_y images_image_id
1312 504 product 0 1257 M 0 atlas-uni-grunt_p_390_20210504_122033.jpg 436 600 1257
1313 505 product 0 1258 M 0 atlas-ultragrunt_p_2246_20211008_093645.jpg 4655 4076 1258
1626 572 product 0 1571 M 0 atlas-sam-100_p_466_20191205_092051.png 436 600 1571
1628 574 product 0 1573 M 0 atlas-sam-200_p_511_20191205_144714.png 436 600 1573
1631 577 product 0 1576 M 0 atlas-postar-20_p_345_20210326_113501.png 436 600 1576
5288 3245 product 0 3177 M 0 atlas-postar-80_p_450_20210408_144425.png 436 600 3177
12840 575 product 0 8753 M 0 atlas-sms-15_p_1277_20191009_100634.png 436 600 8753
12841 576 product 0 8754 M 0 atlas-sms-30_p_1278_20191021_153824.png 436 600 8754
13661 9861 product 0 9248 M 0 atlas-postar-10_p_1418_20210326_105132.png 436 600 9248
30764 10501 product 0 26342 M 0 atlas-uni-grunt-ultra_p_2206_20210322_091620.png 436 600 26342