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 (
    8303, 8665, 9880, 8281, 8286, 9818, 8371, 
    8364, 9883, 8666, 8300, 8365
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00122

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 23 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
11164 8281 product 0 7979 A 0
11571 8665 product 0 8068 A 0
11577 8666 product 0 8074 A 0
11582 8665 product 0 8079 A 0
13325 9818 product 0 8912 A 0
13326 9818 product 0 8913 A 0
13327 9818 product 0 8914 A 0
13328 9818 product 0 8915 A 0
25198 9880 product 0 20785 A 0
25208 9883 product 0 20795 A 0
25843 9880 product 0 21418 A 0
26866 8286 product 0 22441 A 0
26867 8286 product 0 22442 A 0
26868 8286 product 0 22443 A 0
26869 8286 product 0 22444 A 0
26870 8286 product 0 22445 A 0
26871 8286 product 0 22446 A 0
26872 8286 product 0 22447 A 0
26873 8286 product 0 22448 A 0
26921 8303 product 0 22496 A 0
26924 8303 product 0 22499 A 0
26927 8303 product 0 22502 A 0
27989 8300 product 0 23564 A 0
27990 8300 product 0 23565 A 0
27991 8300 product 0 23566 A 0
27992 8300 product 0 23567 A 0
27993 8300 product 0 23568 A 0
27994 8300 product 0 23569 A 0
28310 8665 product 0 23885 A 0
28313 9880 product 0 23888 A 0
28314 9880 product 0 23889 A 0
28315 9880 product 0 23890 A 0
28316 9880 product 0 23891 A 0
28317 8303 product 0 23892 A 0
30223 8666 product 0 25800 A 0
30224 8666 product 0 25801 A 0
30284 8286 product 0 25861 A 0
31466 9883 product 0 27044 A 0
31699 8300 product 0 27277 A 0
10922 8281 product 0 7774 A 1
13324 9818 product 0 8911 A 1
25207 9883 product 0 20794 A 1
25833 8665 product 0 21408 A 1
25836 8666 product 0 21411 A 1
26922 8303 product 0 22497 A 1
10923 8281 product 0 7775 A 2
26923 8303 product 0 22498 A 2
31467 9883 product 0 27045 A 2
10921 8281 product 0 7773 A 3
11573 8665 product 0 8070 A 4
26925 8303 product 0 22500 A 4
28325 8281 product 0 23900 A 4
10925 8281 product 0 7777 A 5
11574 8665 product 0 8071 A 5
10924 8281 product 0 7776 A 6
26926 8303 product 0 22501 A 6
31465 8281 product 0 27043 A 7