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 (
    74539, 74537, 74536, 74535, 74534, 74533, 
    74532, 74531, 74530, 74529, 74528, 
    74527, 74526, 74525, 74524, 74523, 
    74522, 74521, 74520, 74519, 74518, 
    74497, 74462, 74461, 74423, 73854, 
    73847, 73826, 73625, 73600, 73910, 
    73823, 74413, 74412, 74411, 74410, 
    74409, 74408, 74407, 74406
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00088

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 76412 73600 product 79935 M 0
0 76438 73625 product 79961 M 0
0 76638 73823 product 80161 M 0
0 76640 73826 product 80163 M 0
0 76661 73847 product 80184 M 0
0 76668 73854 product 80191 M 0
0 76723 73910 product 80246 M 0
0 77220 74406 product 80743 M 0
0 77221 74407 product 80744 M 0
0 77222 74408 product 80745 M 0
0 77223 74409 product 80746 M 0
0 77224 74410 product 80747 M 0
0 77225 74411 product 80748 M 0
0 77226 74412 product 80749 M 0
0 77227 74413 product 80750 M 0
0 77237 74423 product 80760 M 0
0 77275 74461 product 80798 M 0
0 77276 74462 product 80799 M 0
0 77311 74497 product 80834 M 0
0 77332 74518 product 80855 M 0
0 77333 74519 product 80856 M 0
0 77334 74520 product 80857 M 0
0 77335 74521 product 80858 M 0
0 77336 74522 product 80859 M 0
0 77337 74523 product 80860 M 0
0 77338 74524 product 80861 M 0
0 77339 74525 product 80862 M 0
0 77340 74526 product 80863 M 0
0 77341 74527 product 80864 M 0
0 77342 74528 product 80865 M 0
0 77343 74529 product 80866 M 0
0 77344 74530 product 80867 M 0
0 77345 74531 product 80868 M 0
0 77346 74532 product 80869 M 0
0 77347 74533 product 80870 M 0
0 77348 74534 product 80871 M 0
0 77349 74535 product 80872 M 0
0 77350 74536 product 80873 M 0
0 77351 74537 product 80874 M 0
0 77353 74539 product 80876 M 0