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, 8286, 9818, 9883, 8666, 
    8300, 8306, 8289, 8361, 8304
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00134

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 24 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
10750 8306 product 0 7602 A 0
11189 8306 product 0 8004 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
26885 8289 product 0 22460 A 0
26886 8289 product 0 22461 A 0
26887 8289 product 0 22462 A 0
26919 8304 product 0 22494 A 0
26920 8304 product 0 22495 A 0
26921 8303 product 0 22496 A 0
26924 8303 product 0 22499 A 0
26927 8303 product 0 22502 A 0
26936 8304 product 0 22511 A 0
26937 8304 product 0 22512 A 0
26938 8304 product 0 22513 A 0
27084 8361 product 0 22659 A 0
27089 8361 product 0 22664 A 0
27090 8361 product 0 22665 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
28322 8306 product 0 23897 A 0
28323 8306 product 0 23898 A 0
28324 8306 product 0 23899 A 0
30217 8289 product 0 25794 A 0
30218 8289 product 0 25795 A 0
30219 8289 product 0 25796 A 0
30220 8289 product 0 25797 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
11046 8361 product 0 7860 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
25870 8306 product 0 21445 A 1
26922 8303 product 0 22497 A 1
26923 8303 product 0 22498 A 2
31467 9883 product 0 27045 A 2
10751 8306 product 0 7603 A 3
10752 8306 product 0 7604 A 4
11573 8665 product 0 8070 A 4
26925 8303 product 0 22500 A 4
11574 8665 product 0 8071 A 5
26926 8303 product 0 22501 A 6