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.detailed_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 (10431, 10039, 10420, 10462, 10460) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00091

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 7 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.detailed_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
25837 10039 product 0 21412 A 0 stegu_grenada_0a_1jmz-xq.PNG 596 208 21412
25838 10039 product 0 21413 A 0 stegu_grenada_0b_ktj0-8w.PNG 691 167 21413
29821 10420 product 0 25398 A 0 california_n_5l34-0l.png 1137 357 25398
29822 10420 product 0 25399 A 0 california_p_nltk-bh.png 935 345 25399
29823 10420 product 0 25400 A 0 california-mocca_a4p7-gp.JPG 894 892 25400
29924 10431 product 0 25501 A 0 5.JPG 713 446 25501
30227 10039 product 0 25804 A 0 gre3-corner.JPG 626 660 25804
30236 10462 product 0 25813 A 0 stegu_grenada_0a_1jmz-xq.PNG 596 208 25813
30237 10462 product 0 25814 A 0 stegu_grenada_0b_ktj0-8w.PNG 691 167 25814
31449 10039 product 0 27027 A 0 GRENADA_3_A-2.jpg 1920 1106 27027
29923 10431 product 0 25500 A 1 1_88q9-39.JPG 645 329 25500
30212 10460 product 0 25789 A 1 c680-1_k1s3-hd.JPG 669 477 25789
30203 10460 product 0 25780 A 2 country_p_cxe2-a5.png 973 345 25780
31450 10431 product 0 27028 A 2 MEXICANA_3_a.jpg 1920 1280 27028
29925 10431 product 0 25502 A 3 7_kd8h-r8.JPG 546 727 25502
30204 10460 product 0 25781 A 3 country_n_lkqr-nf.png 1161 349 25781
29926 10431 product 0 25503 A 4 8_m60x-1a.JPG 627 425 25503
30210 10460 product 0 25787 A 4 c680-corner_ijmw-7e.JPG 687 691 25787
30213 10460 product 0 25790 A 5 c680_ryrp-7l.JPG 457 448 25790