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 (
    10444, 10027, 10023, 10044, 10060, 10427, 
    10024, 10035, 10038, 10014, 10016, 
    10047
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00119

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
25834 10038 product 0 21409 A 0
25835 10038 product 0 21410 A 0
26846 10024 product 0 22421 A 0
26847 10024 product 0 22422 A 0
26848 10024 product 0 22423 A 0
26849 10024 product 0 22424 A 0
26874 10027 product 0 22449 A 0
26875 10027 product 0 22450 A 0
26876 10027 product 0 22451 A 0
26877 10027 product 0 22452 A 0
26878 10027 product 0 22453 A 0
26879 10027 product 0 22454 A 0
26880 10027 product 0 22455 A 0
26881 10027 product 0 22456 A 0
26908 10038 product 0 22483 A 0
26915 10035 product 0 22490 A 0
26916 10035 product 0 22491 A 0
26933 10035 product 0 22508 A 0
26934 10035 product 0 22509 A 0
26935 10035 product 0 22510 A 0
27029 10060 product 0 22604 A 0
27030 10060 product 0 22605 A 0
27045 10060 product 0 22620 A 0
27046 10060 product 0 22621 A 0
27061 10047 product 0 22636 A 0
27062 10047 product 0 22637 A 0
27071 10047 product 0 22646 A 0
27072 10047 product 0 22647 A 0
27073 10047 product 0 22648 A 0
27074 10047 product 0 22649 A 0
29881 10427 product 0 25458 A 0
29882 10427 product 0 25459 A 0
29883 10427 product 0 25460 A 0
30035 10444 product 0 25612 A 0
30073 10444 product 0 25650 A 0
30074 10444 product 0 25651 A 0
30075 10444 product 0 25652 A 0
30076 10444 product 0 25653 A 0
30077 10444 product 0 25654 A 0
30216 10044 product 0 25793 A 0
30240 10023 product 0 25817 A 0
31422 10023 product 0 27000 A 0
31425 10024 product 0 27003 A 0
31426 10024 product 0 27004 A 0
32274 10014 product 0 27852 A 0
32292 10016 product 0 27870 A 0
25794 10016 product 0 21369 A 1
26819 10014 product 0 22394 A 1
25795 10016 product 0 21370 A 2
26820 10014 product 0 22395 A 2
31427 10014 product 0 27005 A 3
31428 10014 product 0 27006 A 4
31429 10014 product 0 27007 A 5