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 (
    100564, 100494, 100493, 100477, 100251, 
    100248, 100180, 99431, 99373, 93465, 
    100470, 100446, 100405, 100404, 100403, 
    100393, 100392, 100391, 100300, 100247
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00042

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 96336 93465 product 99859 M 0
0 102415 99373 product 105938 M 0
0 102813 99431 product 106336 M 0
0 103254 100180 product 106777 M 0
0 103323 100247 product 106846 M 0
0 103324 100248 product 106847 M 0
0 103327 100251 product 106850 M 0
0 103377 100300 product 106900 M 0
0 103468 100391 product 106991 M 0
0 103469 100392 product 106992 M 0
0 103470 100393 product 106993 M 0
0 103480 100403 product 107003 M 0
0 103481 100404 product 107004 M 0
0 103482 100405 product 107005 M 0
0 103523 100446 product 107046 M 0
0 103547 100470 product 107070 M 0
0 103553 100477 product 107076 M 0
0 103574 100493 product 107097 M 0
0 103575 100494 product 107098 M 0
0 103645 100564 product 107168 M 0