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 (
    96636, 96635, 96634, 96633, 96632, 96631, 
    96630, 96629, 96628, 96627, 96626, 
    95927, 95925, 95924, 95919, 95918, 
    95917, 95916, 95915, 95914, 95913, 
    95912, 95911, 95910, 95909, 95908, 
    95907, 95906, 95905, 95904, 95903, 
    95902, 95901, 95900, 95899, 96116, 
    96115, 95890, 95889, 95888
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00102

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 98861 95888 product 102384 M 0
0 98862 95889 product 102385 M 0
0 98863 95890 product 102386 M 0
0 98872 95899 product 102395 M 0
0 98873 95900 product 102396 M 0
0 98874 95901 product 102397 M 0
0 98875 95902 product 102398 M 0
0 98876 95903 product 102399 M 0
0 98877 95904 product 102400 M 0
0 98878 95905 product 102401 M 0
0 98879 95906 product 102402 M 0
0 98880 95907 product 102403 M 0
0 98881 95908 product 102404 M 0
0 98882 95909 product 102405 M 0
0 98883 95910 product 102406 M 0
0 98884 95911 product 102407 M 0
0 98885 95912 product 102408 M 0
0 98886 95913 product 102409 M 0
0 98887 95914 product 102410 M 0
0 98888 95915 product 102411 M 0
0 98889 95916 product 102412 M 0
0 98890 95917 product 102413 M 0
0 98891 95918 product 102414 M 0
0 98892 95919 product 102415 M 0
0 98897 95924 product 102420 M 0
0 98898 95925 product 102421 M 0
0 98900 95927 product 102423 M 0
0 99091 96115 product 102614 M 0
0 99092 96116 product 102615 M 0
0 99607 96626 product 103130 M 0
0 99608 96627 product 103131 M 0
0 99609 96628 product 103132 M 0
0 99610 96629 product 103133 M 0
0 99611 96630 product 103134 M 0
0 99612 96631 product 103135 M 0
0 99613 96632 product 103136 M 0
0 99614 96633 product 103137 M 0
0 99615 96634 product 103138 M 0
0 99616 96635 product 103139 M 0
0 99617 96636 product 103140 M 0