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 (
    426, 10670, 10157, 10222, 10223, 395, 
    10163, 8894, 10183, 10181
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00118

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
1080 395 product 0 1057 A 0
12623 8894 product 0 8551 A 0
27401 10163 product 0 22976 A 0
27402 10163 product 0 22977 A 0
28074 10222 product 0 23649 A 0
28081 10222 product 0 23656 A 0
29426 10181 product 0 25003 A 0
29427 10181 product 0 25004 A 0
29428 10181 product 0 25005 A 0
29429 10181 product 0 25006 A 0
29430 10181 product 0 25007 A 0
29431 10181 product 0 25008 A 0
29432 10181 product 0 25009 A 0
29433 10183 product 0 25010 A 0
29434 10183 product 0 25011 A 0
29457 395 product 0 25034 A 0
29458 395 product 0 25035 A 0
29560 10163 product 0 25137 A 0
31335 10223 product 0 26913 A 0
31635 10670 product 0 27213 A 0
32471 10157 product 0 28049 A 0
32472 10157 product 0 28050 A 0
32473 10157 product 0 28051 A 0
32474 10157 product 0 28052 A 0
32475 10157 product 0 28053 A 0
32476 10157 product 0 28054 A 0
32477 10157 product 0 28055 A 0
32538 426 product 0 28116 A 0
3098 395 product 0 2964 A 1
12625 8894 product 0 8553 A 1
32539 426 product 0 28117 A 1
12626 8894 product 0 8554 A 2
28075 10222 product 0 23650 A 2
31630 10670 product 0 27208 A 2
32541 426 product 0 28119 A 2
12627 8894 product 0 8555 A 3
28076 10222 product 0 23651 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
31631 10670 product 0 27209 A 3
32540 426 product 0 28118 A 3
12624 8894 product 0 8552 A 4
31632 10670 product 0 27210 A 4
32544 426 product 0 28122 A 4
31628 10670 product 0 27206 A 5
32542 426 product 0 28120 A 6
31634 10670 product 0 27212 A 7
32543 426 product 0 28121 A 7
27602 426 product 0 23177 A 8
27651 426 product 0 23226 A 9
28300 426 product 0 23875 A 10
31385 426 product 0 26963 A 11
28299 426 product 0 23874 A 12
28301 426 product 0 23876 A 13
31381 426 product 0 26959 A 14
31382 426 product 0 26960 A 15
1202 426 product 0 1179 A 16
1203 426 product 0 1180 A 17
31595 426 product 0 27173 A 18