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 (
    98339, 97666, 98898, 89236, 98794, 98793, 
    98791, 98393, 98772, 98771, 98769, 
    98736, 98734, 98672, 98622, 98523, 
    98170, 92934, 98770, 98161
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00062

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 92039 89236 product 95562 M 0
0 95798 92934 product 99321 M 0
0 101183 98161 product 104706 M 0
0 101192 98170 product 104715 M 0
0 101370 97666 product 104893 M 0
0 101375 98339 product 104898 M 0
0 101429 98393 product 104952 M 0
0 101598 98523 product 105121 M 0
0 101662 98622 product 105185 M 0
0 101710 98672 product 105233 M 0
0 101773 98736 product 105296 M 0
0 101808 98770 product 105331 M 0
0 101809 98771 product 105332 M 0
0 101810 98772 product 105333 M 0
0 101811 98734 product 105334 M 0
0 101830 98791 product 105353 M 0
0 101832 98793 product 105355 M 0
0 101833 98794 product 105356 M 0
0 101938 98898 product 105461 M 0
0 103571 98769 product 107094 M 0