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.detailed_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.00056

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.detailed_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 505265339174013497588155073af5fd0f13.jpg 1000 1000 10579 10568 product 14102 M 0 14102
0 505265339137513497588255073af69b304c.jpg 1000 1000 10584 10573 product 14107 M 0 14107
0 50526533865791350363611507ce9dbf23c2.jpg 1000 1000 10651 10639 product 14174 M 0 14174
0 50526534084861350536404507f8cd46dfa9.jpg 1000 1000 10658 10646 product 14181 M 0 14181
0 5052653386562.jpg 1000 1000 10702 10690 product 14225 M 0 14225
0 505265338656213509684155086245f1aec7.jpg 1000 1000 10705 10693 product 14228 M 0 14228
0 5052653404266.jpg 1000 1000 10832 10820 product 14355 M 0 14355
0 50526534193901351400416508cbbe025e62.jpg 1000 1000 11471 11460 product 14994 M 0 14994
0 Ruff_Cut_Logo_(Master)1351453772508d8c4c28eb9.jpg 886 886 11474 11463 product 14997 M 0 14997
0 5052653436861.jpg 1000 1000 11636 11625 product 15159 M 0 15159
0 MOJO018_Web1000.jpg 1000 1000 11657 11646 product 15180 M 0 15180
0 5052653449618.jpg 1000 1000 11750 11739 product 15273 M 0 15273
0 5052653407069.jpg 1000 1000 11896 11885 product 15419 M 0 15419
0 5052653407113.jpg 1000 1000 12110 12099 product 15633 M 0 15633
0 5052653407144.jpg 1000 1000 12177 12166 product 15700 M 0 15700
0 5052653470797.jpg 1000 1000 12185 12174 product 15708 M 0 15708
0 5052653452830.jpg 1000 1000 12252 12241 product 15775 M 0 15775
0 5052653461818.jpg 1000 1000 12270 12259 product 15793 M 0 15793
0 505265389909313845780265286fbea15a82.jpg 1000 1000 18750 18743 product 22273 M 0 22273
0 5052653920629.jpg 1000 1000 21848 21831 product 25371 M 0 25371