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 (
    95595, 95594, 95593, 95592, 95591, 95590, 
    95589, 95588, 95587, 95586, 95585, 
    95584, 95583, 95582, 95581, 95580, 
    95579, 95578, 95577, 95576, 95575, 
    95574, 95573, 95572, 95571, 94905, 
    95440, 95439, 94679, 94678, 94677, 
    94676, 94675, 94674, 94673, 94672, 
    94659, 94629, 94628, 94626
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00070

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 97514 94626 product 101037 M 0
0 97516 94628 product 101039 M 0
0 97517 94629 product 101040 M 0
0 97547 94659 product 101070 M 0
0 97560 94672 product 101083 M 0
0 97561 94673 product 101084 M 0
0 97562 94674 product 101085 M 0
0 97563 94675 product 101086 M 0
0 97564 94676 product 101087 M 0
0 97565 94677 product 101088 M 0
0 97566 94678 product 101089 M 0
0 97567 94679 product 101090 M 0
0 97797 94905 product 101320 M 0
0 98361 95439 product 101884 M 0
0 98362 95440 product 101885 M 0
0 98493 95571 product 102016 M 0
0 98494 95572 product 102017 M 0
0 98495 95573 product 102018 M 0
0 98496 95574 product 102019 M 0
0 98497 95575 product 102020 M 0
0 98498 95576 product 102021 M 0
0 98499 95577 product 102022 M 0
0 98500 95578 product 102023 M 0
0 98501 95579 product 102024 M 0
0 98502 95580 product 102025 M 0
0 98503 95581 product 102026 M 0
0 98504 95582 product 102027 M 0
0 98505 95583 product 102028 M 0
0 98506 95584 product 102029 M 0
0 98507 95585 product 102030 M 0
0 98508 95586 product 102031 M 0
0 98509 95587 product 102032 M 0
0 98510 95588 product 102033 M 0
0 98511 95589 product 102034 M 0
0 98512 95590 product 102035 M 0
0 98513 95591 product 102036 M 0
0 98514 95592 product 102037 M 0
0 98515 95593 product 102038 M 0
0 98516 95594 product 102039 M 0
0 98517 95595 product 102040 M 0