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 (
    67760, 67759, 67758, 67757, 67756, 67755, 
    67754, 67753, 67752, 67751, 67694, 
    68134, 68133, 68127, 68126, 68049, 
    67865, 67682, 67681, 67663, 67590, 
    66816, 67969, 67968, 67967, 67966, 
    67838, 67729, 67709, 67680, 67679, 
    67584, 66815, 67692, 67638, 67637, 
    67317, 67532, 67917, 67916
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00068

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 69079 66815 product 72602 M 0
0 69080 66816 product 72603 M 0
0 69582 67317 product 73105 M 0
0 69796 67532 product 73319 M 0
0 69848 67584 product 73371 M 0
0 69855 67590 product 73378 M 0
0 69902 67637 product 73425 M 0
0 69903 67638 product 73426 M 0
0 69928 67663 product 73451 M 0
0 69944 67679 product 73467 M 0
0 69945 67680 product 73468 M 0
0 69946 67681 product 73469 M 0
0 69947 67682 product 73470 M 0
0 69957 67692 product 73480 M 0
0 69959 67694 product 73482 M 0
0 69995 67729 product 73518 M 0
0 70017 67751 product 73540 M 0
0 70018 67752 product 73541 M 0
0 70019 67753 product 73542 M 0
0 70020 67754 product 73543 M 0
0 70021 67755 product 73544 M 0
0 70022 67756 product 73545 M 0
0 70023 67757 product 73546 M 0
0 70024 67758 product 73547 M 0
0 70025 67759 product 73548 M 0
0 70026 67760 product 73549 M 0
0 70104 67838 product 73627 M 0
0 70131 67865 product 73654 M 0
0 70182 67916 product 73705 M 0
0 70183 67917 product 73706 M 0
0 70233 67966 product 73756 M 0
0 70235 67968 product 73758 M 0
0 70237 67969 product 73760 M 0
0 70317 68049 product 73840 M 0
0 70394 68126 product 73917 M 0
0 70395 68127 product 73918 M 0
0 70401 68133 product 73924 M 0
0 70402 68134 product 73925 M 0
0 98845 67967 product 102368 M 0
0 100709 67709 product 104232 M 0