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.image_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 (
    8312, 10699, 8352, 9463, 8313, 10071, 
    8314, 414, 10073, 8373, 10072, 1628
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00104

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 19 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.image_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
1032 414 product 0 1009 A 0
3557 414 product 0 2998 A 0
11008 8352 product 0 7822 A 0
11140 8373 product 0 7955 A 0
11141 8373 product 0 7956 A 0
11219 8314 product 0 8040 A 0
11220 8314 product 0 8041 A 0
11221 8313 product 0 8042 A 0
11222 8313 product 0 8043 A 0
11223 8313 product 0 8044 A 0
11224 8314 product 0 8045 A 0
11850 8312 product 0 8324 A 0
11852 8373 product 0 8326 A 0
11853 8373 product 0 8327 A 0
11854 8313 product 0 8328 A 0
11855 8314 product 0 8329 A 0
11856 8314 product 0 8330 A 0
29360 9463 product 0 24937 A 0
31790 10699 product 0 27368 A 0
32580 8314 product 0 28158 A 0
32581 8314 product 0 28159 A 0
10999 8352 product 0 7820 A 1
11851 8312 product 0 8325 A 1
31780 10699 product 0 27358 A 1
11000 8352 product 0 7821 A 2
27356 8352 product 0 22931 A 2
27357 8352 product 0 22932 A 2
27358 8352 product 0 22933 A 2
31776 10699 product 0 27354 A 2
32578 8312 product 0 28156 A 2
31778 10699 product 0 27356 A 3
32579 8312 product 0 28157 A 3
32582 10699 product 0 28160 A 3
32583 10699 product 0 28161 A 3
11225 8312 product 0 8046 A 4