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 = 'fr' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    9935, 9943, 9939, 9947, 9945, 9936, 9940, 
    9937, 9944, 9946, 9957, 9941
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00111

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
25441 9935 product 0 21028 A 0
25443 9941 product 0 21030 A 0
25445 9940 product 0 21032 A 0
25447 9939 product 0 21034 A 0
25449 9936 product 0 21036 A 0
25469 9940 product 0 21044 A 0
25472 9937 product 0 21047 A 0
25481 9943 product 0 21056 A 0
25482 9943 product 0 21057 A 0
25484 9944 product 0 21059 A 0
25485 9944 product 0 21060 A 0
25487 9945 product 0 21062 A 0
25490 9946 product 0 21065 A 0
25503 9947 product 0 21078 A 0
25504 9947 product 0 21079 A 0
27320 9957 product 0 22895 A 0
31600 9944 product 0 27178 A 0
31601 9944 product 0 27179 A 0
31602 9944 product 0 27180 A 0
31603 9944 product 0 27181 A 0
31604 9944 product 0 27182 A 0
25453 9941 product 0 21040 A 1
25541 9957 product 0 21116 A 1
31581 9945 product 0 27159 A 1
31584 9936 product 0 27162 A 1
31587 9946 product 0 27165 A 1
31588 9939 product 0 27166 A 1
31590 9937 product 0 27168 A 1
31606 9935 product 0 27184 A 1
25451 9935 product 0 21038 A 2
25491 9946 product 0 21066 A 2
31580 9945 product 0 27158 A 2
31585 9936 product 0 27163 A 2
31589 9939 product 0 27167 A 2
31591 9937 product 0 27169 A 2
31597 9941 product 0 27175 A 2
25452 9936 product 0 21039 A 3
25470 9939 product 0 21045 A 3
31582 9945 product 0 27160 A 3
31592 9937 product 0 27170 A 3
31598 9941 product 0 27176 A 3
31607 9935 product 0 27185 A 3
31583 9945 product 0 27161 A 4
31586 9936 product 0 27164 A 4
31593 9937 product 0 27171 A 4
31599 9941 product 0 27177 A 4
25488 9945 product 0 21063 A 5
31594 9937 product 0 27172 A 5
25473 9937 product 0 21048 A 6