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 (
    11485, 10960, 10201, 397, 10188, 10353, 
    10355, 1655, 388, 395, 10163, 9871
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00132

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 31 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
1080 395 product 0 1057 A 0
1947 388 product 0 1892 A 0
1962 397 product 0 1908 A 0
11822 1655 product 0 8296 A 0
11823 1655 product 0 8297 A 0
25147 9871 product 0 20734 A 0
25148 9871 product 0 20735 A 0
25149 9871 product 0 20736 A 0
27401 10163 product 0 22976 A 0
27402 10163 product 0 22977 A 0
27669 10201 product 0 23244 A 0
27674 1655 product 0 23249 A 0
29457 395 product 0 25034 A 0
29458 395 product 0 25035 A 0
29560 10163 product 0 25137 A 0
31289 10355 product 0 26867 A 0
31553 10188 product 0 27131 A 0
31560 10353 product 0 27138 A 0
32666 11485 product 0 28244 A 0
32667 11485 product 0 28245 A 0
32668 11485 product 0 28246 A 0
32669 11485 product 0 28247 A 0
32670 11485 product 0 28248 A 0
32678 10960 product 0 28256 A 0
1077 397 product 0 1054 A 1
3098 395 product 0 2964 A 1
11093 388 product 0 7907 A 1
27611 10188 product 0 23186 A 1
27670 10201 product 0 23245 A 1
28260 10353 product 0 23835 A 1
32672 10960 product 0 28250 A 1
1069 388 product 0 1046 A 2
1963 397 product 0 1909 A 2
27668 10201 product 0 23243 A 2
31270 10353 product 0 26848 A 2
31554 10188 product 0 27132 A 2
32673 10960 product 0 28251 A 2
1946 388 product 0 1891 A 3
27671 10201 product 0 23246 A 3
29459 395 product 0 25036 A 3
29460 395 product 0 25037 A 3
29461 395 product 0 25038 A 3
29462 395 product 0 25039 A 3
31217 397 product 0 26795 A 3
31271 10353 product 0 26849 A 3
31555 10188 product 0 27133 A 3
32674 10960 product 0 28252 A 3
11091 388 product 0 7905 A 4
27672 10201 product 0 23247 A 4
31272 10353 product 0 26850 A 4
31556 10188 product 0 27134 A 4
32675 10960 product 0 28253 A 4
31273 10353 product 0 26851 A 5
31557 10188 product 0 27135 A 5
32676 10960 product 0 28254 A 5
31274 10353 product 0 26852 A 6
31558 10188 product 0 27136 A 6
32677 10960 product 0 28255 A 6
31559 10188 product 0 27137 A 7
31561 10353 product 0 27139 A 7
27612 10188 product 0 23187 A 8
31562 10353 product 0 27140 A 8
27613 10188 product 0 23188 A 9
31563 10353 product 0 27141 A 9
27614 10188 product 0 23189 A 10
31564 10353 product 0 27142 A 10
27615 10188 product 0 23190 A 11
31565 10353 product 0 27143 A 11
27616 10188 product 0 23191 A 12
31566 10353 product 0 27144 A 12
27617 10188 product 0 23192 A 13
31567 10353 product 0 27145 A 13
31568 10353 product 0 27146 A 14
31569 10353 product 0 27147 A 15
31570 10353 product 0 27148 A 16
31571 10353 product 0 27149 A 17
31572 10353 product 0 27150 A 18
31573 10353 product 0 27151 A 19