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 (
    10022, 10029, 10025, 10057, 10062, 10036, 
    10019, 10052, 10028, 10059, 10419, 
    10049
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00121

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 21 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
25867 10036 product 0 21442 A 0
26841 10019 product 0 22416 A 0
26854 10025 product 0 22429 A 0
26855 10025 product 0 22430 A 0
26856 10025 product 0 22431 A 0
26857 10025 product 0 22432 A 0
26884 10029 product 0 22459 A 0
26894 10028 product 0 22469 A 0
26895 10028 product 0 22470 A 0
26896 10028 product 0 22471 A 0
26897 10028 product 0 22472 A 0
26898 10028 product 0 22473 A 0
26899 10028 product 0 22474 A 0
26957 10057 product 0 22532 A 0
26958 10057 product 0 22533 A 0
26963 10057 product 0 22538 A 0
26964 10057 product 0 22539 A 0
26965 10057 product 0 22540 A 0
26966 10057 product 0 22541 A 0
26967 10057 product 0 22542 A 0
26968 10057 product 0 22543 A 0
26969 10057 product 0 22544 A 0
26977 10057 product 0 22552 A 0
26989 10052 product 0 22564 A 0
26990 10052 product 0 22565 A 0
27001 10052 product 0 22576 A 0
27002 10052 product 0 22577 A 0
27003 10052 product 0 22578 A 0
27004 10052 product 0 22579 A 0
27027 10059 product 0 22602 A 0
27028 10059 product 0 22603 A 0
27033 10062 product 0 22608 A 0
27034 10062 product 0 22609 A 0
27039 10059 product 0 22614 A 0
27040 10059 product 0 22615 A 0
27041 10059 product 0 22616 A 0
27042 10059 product 0 22617 A 0
27051 10062 product 0 22626 A 0
27052 10062 product 0 22627 A 0
27065 10049 product 0 22640 A 0
27066 10049 product 0 22641 A 0
29815 10419 product 0 25392 A 0
29816 10419 product 0 25393 A 0
29819 10419 product 0 25396 A 0
29820 10419 product 0 25397 A 0
30283 10062 product 0 25860 A 0
32276 10022 product 0 27854 A 0
25868 10036 product 0 21443 A 1
26821 10022 product 0 22396 A 1
26839 10019 product 0 22414 A 1
26882 10029 product 0 22457 A 1
26822 10022 product 0 22397 A 2
26840 10019 product 0 22415 A 2
26883 10029 product 0 22458 A 2
26909 10036 product 0 22484 A 2
26823 10022 product 0 22398 A 3
31430 10036 product 0 27008 A 3
26910 10036 product 0 22485 A 4
26911 10036 product 0 22486 A 5