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 (
    3524, 9985, 10466, 9989, 10463, 10418, 
    10405, 10417, 10465, 10385, 10464, 
    10373
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00152

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 19 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
25619 3524 product 0 21194 A 0
25690 9985 product 0 21265 A 0
25691 9985 product 0 21266 A 0
25702 9989 product 0 21277 A 0
25703 9989 product 0 21278 A 0
29441 10373 product 0 25018 A 0
29442 10373 product 0 25019 A 0
29443 10373 product 0 25020 A 0
29444 10373 product 0 25021 A 0
29534 10385 product 0 25111 A 0
29535 10385 product 0 25112 A 0
29536 10385 product 0 25113 A 0
29538 10385 product 0 25115 A 0
29540 10385 product 0 25117 A 0
29657 10405 product 0 25234 A 0
29658 10405 product 0 25235 A 0
29659 10405 product 0 25236 A 0
29660 10405 product 0 25237 A 0
29802 10417 product 0 25379 A 0
29803 10417 product 0 25380 A 0
29804 10417 product 0 25381 A 0
29805 10417 product 0 25382 A 0
29807 10418 product 0 25384 A 0
29808 10418 product 0 25385 A 0
29809 10418 product 0 25386 A 0
29810 10418 product 0 25387 A 0
30303 10463 product 0 25880 A 0
30304 10463 product 0 25881 A 0
30305 10463 product 0 25882 A 0
30306 10463 product 0 25883 A 0
30308 10464 product 0 25885 A 0
30309 10464 product 0 25886 A 0
30310 10464 product 0 25887 A 0
30311 10464 product 0 25888 A 0
30313 10465 product 0 25890 A 0
30314 10465 product 0 25891 A 0
30315 10465 product 0 25892 A 0
30316 10465 product 0 25893 A 0
30318 10466 product 0 25895 A 0
30319 10466 product 0 25896 A 0
30320 10466 product 0 25897 A 0
30321 10466 product 0 25898 A 0
5658 3524 product 0 3295 A 1
5657 3524 product 0 3294 A 2
5659 3524 product 0 3296 A 3
5672 3524 product 0 3309 A 4
5673 3524 product 0 3310 A 5