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 (
    67356, 67355, 67354, 67353, 67352, 67351, 
    67350, 67349, 67348, 67347, 67346, 
    67345, 67344, 67314, 67313, 76804, 
    76803, 76802, 76801, 76800, 76799, 
    76798, 76797, 76796, 76795, 76794, 
    67193, 67179, 67178, 67177, 67176, 
    67175, 67174, 67173, 67172, 67171, 
    67170, 67169, 67168, 67167
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00072

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 69431 67167 product 72954 M 0
0 69432 67168 product 72955 M 0
0 69433 67169 product 72956 M 0
0 69434 67170 product 72957 M 0
0 69435 67171 product 72958 M 0
0 69436 67172 product 72959 M 0
0 69437 67173 product 72960 M 0
0 69438 67174 product 72961 M 0
0 69439 67175 product 72962 M 0
0 69440 67176 product 72963 M 0
0 69441 67177 product 72964 M 0
0 69442 67178 product 72965 M 0
0 69443 67179 product 72966 M 0
0 69457 67193 product 72980 M 0
0 69578 67313 product 73101 M 0
0 69579 67314 product 73102 M 0
0 69609 67344 product 73132 M 0
0 69610 67345 product 73133 M 0
0 69611 67346 product 73134 M 0
0 69612 67347 product 73135 M 0
0 69613 67348 product 73136 M 0
0 69614 67349 product 73137 M 0
0 69615 67350 product 73138 M 0
0 69616 67351 product 73139 M 0
0 69617 67352 product 73140 M 0
0 69618 67353 product 73141 M 0
0 69619 67354 product 73142 M 0
0 69620 67355 product 73143 M 0
0 69621 67356 product 73144 M 0
0 79643 76794 product 83166 M 0
0 79644 76795 product 83167 M 0
0 79645 76796 product 83168 M 0
0 79646 76797 product 83169 M 0
0 79647 76798 product 83170 M 0
0 79648 76799 product 83171 M 0
0 79649 76800 product 83172 M 0
0 79650 76801 product 83173 M 0
0 79651 76802 product 83174 M 0
0 79652 76803 product 83175 M 0
0 79653 76804 product 83176 M 0