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 (
    112329, 112328, 112327, 112321, 112287, 
    112286, 112285, 112284, 112283, 112282, 
    112281, 112280, 112279, 112278, 112277, 
    112276, 112275, 112274, 112273, 112272
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00059

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 115441 112272 product 118964 M 0
0 115442 112273 product 118965 M 0
0 115443 112274 product 118966 M 0
0 115444 112275 product 118967 M 0
0 115445 112276 product 118968 M 0
0 115446 112277 product 118969 M 0
0 115447 112278 product 118970 M 0
0 115448 112279 product 118971 M 0
0 115449 112280 product 118972 M 0
0 115450 112281 product 118973 M 0
0 115451 112282 product 118974 M 0
0 115452 112283 product 118975 M 0
0 115453 112284 product 118976 M 0
0 115454 112285 product 118977 M 0
0 115455 112286 product 118978 M 0
0 115456 112287 product 118979 M 0
0 115490 112321 product 119013 M 0
0 115496 112327 product 119019 M 0
0 115497 112328 product 119020 M 0
0 115498 112329 product 119021 M 0