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 (
    10043, 10042, 10414, 10040, 10030, 10032, 
    10461, 10435, 10442, 10425, 10429, 
    10445
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00114

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 15 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
25844 10030 product 0 21419 A 0
25845 10030 product 0 21420 A 0
26902 10040 product 0 22477 A 0
26903 10040 product 0 22478 A 0
28109 10032 product 0 23684 A 0
28144 10042 product 0 23719 A 0
29714 10414 product 0 25291 A 0
29722 10414 product 0 25299 A 0
29723 10414 product 0 25300 A 0
29862 10425 product 0 25439 A 0
29863 10425 product 0 25440 A 0
29864 10425 product 0 25441 A 0
29866 10425 product 0 25443 A 0
29950 10435 product 0 25527 A 0
30000 10442 product 0 25577 A 0
30001 10442 product 0 25578 A 0
30007 10442 product 0 25584 A 0
30008 10442 product 0 25585 A 0
30009 10442 product 0 25586 A 0
30010 10442 product 0 25587 A 0
30011 10442 product 0 25588 A 0
30044 10445 product 0 25621 A 0
30045 10445 product 0 25622 A 0
30046 10445 product 0 25623 A 0
30242 10032 product 0 25819 A 0
30259 10040 product 0 25836 A 0
30260 10040 product 0 25837 A 0
31436 10043 product 0 27014 A 0
31437 10043 product 0 27015 A 0
31438 10042 product 0 27016 A 0
31439 10042 product 0 27017 A 0
31440 10042 product 0 27018 A 0
31441 10042 product 0 27019 A 0
31442 10040 product 0 27020 A 0
31443 10030 product 0 27021 A 0
31444 10032 product 0 27022 A 0
29902 10429 product 0 25479 A 1
30230 10461 product 0 25807 A 1
31451 10435 product 0 27029 A 1
29904 10429 product 0 25481 A 2
30231 10461 product 0 25808 A 2
31452 10435 product 0 27030 A 2
29951 10435 product 0 25528 A 3
29952 10435 product 0 25529 A 4