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 (
    94625, 94624, 94623, 94622, 94621, 94620, 
    94619, 94618, 94617, 94616, 94615, 
    94614, 94613, 94612, 94611, 94610, 
    94609, 94608, 94607, 94606, 94605, 
    94604, 94603, 94602, 94601, 94600, 
    94599, 94598, 94597, 94596, 94595, 
    94594, 94593, 95222, 95221, 95220, 
    95219, 94863, 94862, 94697
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00082

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 97481 94593 product 101004 M 0
0 97482 94594 product 101005 M 0
0 97483 94595 product 101006 M 0
0 97484 94596 product 101007 M 0
0 97485 94597 product 101008 M 0
0 97486 94598 product 101009 M 0
0 97487 94599 product 101010 M 0
0 97488 94600 product 101011 M 0
0 97489 94601 product 101012 M 0
0 97490 94602 product 101013 M 0
0 97491 94603 product 101014 M 0
0 97492 94604 product 101015 M 0
0 97493 94605 product 101016 M 0
0 97494 94606 product 101017 M 0
0 97495 94607 product 101018 M 0
0 97496 94608 product 101019 M 0
0 97497 94609 product 101020 M 0
0 97498 94610 product 101021 M 0
0 97499 94611 product 101022 M 0
0 97500 94612 product 101023 M 0
0 97501 94613 product 101024 M 0
0 97502 94614 product 101025 M 0
0 97503 94615 product 101026 M 0
0 97504 94616 product 101027 M 0
0 97505 94617 product 101028 M 0
0 97506 94618 product 101029 M 0
0 97507 94619 product 101030 M 0
0 97508 94620 product 101031 M 0
0 97509 94621 product 101032 M 0
0 97510 94622 product 101033 M 0
0 97511 94623 product 101034 M 0
0 97512 94624 product 101035 M 0
0 97513 94625 product 101036 M 0
0 97585 94697 product 101108 M 0
0 97754 94862 product 101277 M 0
0 97755 94863 product 101278 M 0
0 98115 95219 product 101638 M 0
0 98116 95220 product 101639 M 0
0 98117 95221 product 101640 M 0
0 98118 95222 product 101641 M 0