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 (
    96513, 96512, 96511, 96510, 96503, 96384, 
    96086, 95838, 94773, 95878, 96342, 
    96341, 96340, 96343, 96337, 96336, 
    96335, 96322, 96313, 96182
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00050

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 97661 94773 product 101184 M 0
0 98762 95838 product 102285 M 0
0 98850 95878 product 102373 M 0
0 99062 96086 product 102585 M 0
0 99158 96182 product 102681 M 0
0 99289 96313 product 102812 M 0
0 99298 96322 product 102821 M 0
0 99311 96335 product 102834 M 0
0 99312 96336 product 102835 M 0
0 99313 96337 product 102836 M 0
0 99317 96341 product 102840 M 0
0 99318 96342 product 102841 M 0
0 99319 96343 product 102842 M 0
0 99324 96340 product 102847 M 0
0 99360 96384 product 102883 M 0
0 99478 96503 product 103001 M 0
0 99485 96510 product 103008 M 0
0 99486 96511 product 103009 M 0
0 99487 96512 product 103010 M 0
0 99488 96513 product 103011 M 0