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 (
    96860, 96859, 96858, 96857, 96856, 96855, 
    96854, 96853, 96852, 96851, 96850, 
    96849, 96848, 96058, 96888, 96045, 
    96044, 96042, 96041, 96000, 96690, 
    96689, 96688, 96687, 96686, 96685, 
    96684, 96683, 96682, 96681, 96680, 
    96679, 96678, 96677, 96676, 96643, 
    96640, 96639, 96638, 96637
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00098

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 40 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 98973 96000 product 102496 M 0
0 99015 96041 product 102538 M 0
0 99016 96042 product 102539 M 0
0 99018 96044 product 102541 M 0
0 99019 96045 product 102542 M 0
0 99032 96058 product 102555 M 0
0 99618 96637 product 103141 M 0
0 99619 96638 product 103142 M 0
0 99620 96639 product 103143 M 0
0 99621 96640 product 103144 M 0
0 99624 96643 product 103147 M 0
0 99657 96676 product 103180 M 0
0 99658 96677 product 103181 M 0
0 99659 96678 product 103182 M 0
0 99660 96679 product 103183 M 0
0 99661 96680 product 103184 M 0
0 99662 96681 product 103185 M 0
0 99663 96682 product 103186 M 0
0 99664 96683 product 103187 M 0
0 99665 96684 product 103188 M 0
0 99666 96685 product 103189 M 0
0 99667 96686 product 103190 M 0
0 99668 96687 product 103191 M 0
0 99669 96688 product 103192 M 0
0 99670 96689 product 103193 M 0
0 99671 96690 product 103194 M 0
0 99830 96848 product 103353 M 0
0 99831 96849 product 103354 M 0
0 99832 96850 product 103355 M 0
0 99833 96851 product 103356 M 0
0 99834 96852 product 103357 M 0
0 99835 96853 product 103358 M 0
0 99836 96854 product 103359 M 0
0 99837 96855 product 103360 M 0
0 99838 96856 product 103361 M 0
0 99839 96857 product 103362 M 0
0 99840 96858 product 103363 M 0
0 99841 96859 product 103364 M 0
0 99842 96860 product 103365 M 0
0 99870 96888 product 103393 M 0