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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    9861, 3520, 580, 8347, 1167, 3246, 1162, 
    1196, 1193, 1628, 583, 1159
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00077

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 13 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
10994 8347 product 0 7815 A 0 atlas_zt_02.jpg 521 478 7815
10995 8347 product 0 7816 A 0 atlas_zt_04.jpg 422 296 7816
10996 8347 product 0 7817 A 0 atlas_zt_03.jpg 520 392 7817
11074 1196 product 0 7888 A 0 silikat_paleta_03.png 558 332 7888
11075 1196 product 0 7889 A 0 silikat_paleta_02.png 544 170 7889
12774 580 product 0 8687 A 0 atlas_elastified_02.jpg 617 516 8687
12775 580 product 0 8688 A 0 atlas_elastified_03.jpg 508 232 8688
13659 9861 product 0 9246 A 0 Postar_20_02.jpg 614 447 9246
13660 9861 product 0 9247 A 0 Postar_20_03.jpg 493 421 9247