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 (
    9878, 10434, 10426, 10034, 10413, 9881, 
    10033, 10438, 10441, 10041, 10440, 
    10037
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00116

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 18 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
25188 9878 product 0 20775 A 0
25201 9881 product 0 20788 A 0
25865 10037 product 0 21440 A 0
25866 10037 product 0 21441 A 0
26900 10041 product 0 22475 A 0
26901 10041 product 0 22476 A 0
26912 10037 product 0 22487 A 0
26913 10037 product 0 22488 A 0
26914 10037 product 0 22489 A 0
26917 10034 product 0 22492 A 0
26918 10034 product 0 22493 A 0
26928 10034 product 0 22503 A 0
26929 10034 product 0 22504 A 0
26930 10034 product 0 22505 A 0
26931 10034 product 0 22506 A 0
26932 10034 product 0 22507 A 0
29706 10413 product 0 25283 A 0
29713 10413 product 0 25290 A 0
29874 10426 product 0 25451 A 0
29875 10426 product 0 25452 A 0
29876 10426 product 0 25453 A 0
29941 10434 product 0 25518 A 0
29942 10434 product 0 25519 A 0
29943 10434 product 0 25520 A 0
29944 10434 product 0 25521 A 0
29945 10434 product 0 25522 A 0
29946 10434 product 0 25523 A 0
29971 10438 product 0 25548 A 0
29972 10438 product 0 25549 A 0
29973 10438 product 0 25550 A 0
29987 10440 product 0 25564 A 0
29988 10440 product 0 25565 A 0
29989 10440 product 0 25566 A 0
29990 10440 product 0 25567 A 0
29992 10441 product 0 25569 A 0
29993 10441 product 0 25570 A 0
29995 10441 product 0 25572 A 0
29996 10441 product 0 25573 A 0
29997 10441 product 0 25574 A 0
29998 10441 product 0 25575 A 0
29999 10441 product 0 25576 A 0
30235 9881 product 0 25812 A 0
31417 10041 product 0 26995 A 0
31418 10041 product 0 26996 A 0
31419 10041 product 0 26997 A 0
31420 10041 product 0 26998 A 0
31421 10041 product 0 26999 A 0
31423 10037 product 0 27001 A 0
31424 10037 product 0 27002 A 0
31482 10413 product 0 27060 A 0
32285 10033 product 0 27863 A 0
25831 10033 product 0 21406 A 1
31415 9878 product 0 26993 A 1
25832 10033 product 0 21407 A 2
25839 9878 product 0 21414 A 2
26905 10033 product 0 22480 A 3
30225 9878 product 0 25802 A 3
30226 9878 product 0 25803 A 4