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 (
    88272, 89076, 89032, 89031, 89027, 88842, 
    88839, 88838, 88837, 88836, 88835, 
    88834, 88833, 88832, 88319, 88318, 
    88317, 88316, 88315, 88314
  ) 
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 91044 88272 product 94567 M 0
0 91087 88314 product 94610 M 0
0 91088 88315 product 94611 M 0
0 91089 88316 product 94612 M 0
0 91090 88317 product 94613 M 0
0 91091 88318 product 94614 M 0
0 91092 88319 product 94615 M 0
0 91631 88832 product 95154 M 0
0 91632 88833 product 95155 M 0
0 91633 88834 product 95156 M 0
0 91634 88835 product 95157 M 0
0 91635 88836 product 95158 M 0
0 91636 88837 product 95159 M 0
0 91637 88838 product 95160 M 0
0 91638 88839 product 95161 M 0
0 91641 88842 product 95164 M 0
0 91829 89027 product 95352 M 0
0 91833 89031 product 95356 M 0
0 91834 89032 product 95357 M 0
0 91878 89076 product 95401 M 0