SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  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 = 'M' 
  AND cscart_images_links.object_id IN (
    21831, 18743, 12099, 12259, 12174, 12166, 
    12241, 11885, 11739, 11625, 11646, 
    11460, 11463, 10820, 10693, 10690, 
    10646, 10639, 10573, 10568
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00051

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 20 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 4 toolboxdigitalshop_dev.cscart_images_links.image_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where

Result

image_id image_path image_x image_y pair_id object_id object_type detailed_id type position alt images_image_id
0 10579 10568 product 14102 M 0
0 10584 10573 product 14107 M 0
0 10651 10639 product 14174 M 0
0 10658 10646 product 14181 M 0
0 10702 10690 product 14225 M 0
0 10705 10693 product 14228 M 0
0 10832 10820 product 14355 M 0
0 11471 11460 product 14994 M 0
0 11474 11463 product 14997 M 0
0 11636 11625 product 15159 M 0
0 11657 11646 product 15180 M 0
0 11750 11739 product 15273 M 0
0 11896 11885 product 15419 M 0
0 12110 12099 product 15633 M 0
0 12177 12166 product 15700 M 0
0 12185 12174 product 15708 M 0
0 12252 12241 product 15775 M 0
0 12270 12259 product 15793 M 0
0 18750 18743 product 22273 M 0
0 21848 21831 product 25371 M 0