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 (
    73240, 73116, 72858, 72857, 73405, 73404, 
    73403, 73155, 73115, 73351, 73350, 
    73349, 73348, 72836, 73284, 73111, 
    71691, 68825, 49338, 44239, 44238, 
    42033, 73271, 73270, 73252, 73239, 
    73237, 73217, 73156, 73119, 72856, 
    72855, 72852, 72032, 71703, 71486, 
    71485, 71484, 71483, 73020
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00066

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 43547 42033 product 47070 M 0
0 45746 44238 product 49269 M 0
0 45747 44239 product 49270 M 0
0 50843 49338 product 54366 M 0
0 71095 68825 product 74618 M 0
0 74290 71483 product 77813 M 0
0 74291 71484 product 77814 M 0
0 74292 71485 product 77815 M 0
0 74293 71486 product 77816 M 0
0 74500 71691 product 78023 M 0
0 74512 71703 product 78035 M 0
0 74841 72032 product 78364 M 0
0 75645 72836 product 79168 M 0
0 75661 72852 product 79184 M 0
0 75664 72855 product 79187 M 0
0 75665 72856 product 79188 M 0
0 75666 72857 product 79189 M 0
0 75667 72858 product 79190 M 0
0 75830 73020 product 79353 M 0
0 75921 73111 product 79444 M 0
0 75925 73115 product 79448 M 0
0 75926 73116 product 79449 M 0
0 75967 73155 product 79490 M 0
0 75968 73156 product 79491 M 0
0 76029 73217 product 79552 M 0
0 76049 73237 product 79572 M 0
0 76051 73239 product 79574 M 0
0 76052 73240 product 79575 M 0
0 76064 73252 product 79587 M 0
0 76082 73270 product 79605 M 0
0 76083 73271 product 79606 M 0
0 76096 73284 product 79619 M 0
0 76160 73348 product 79683 M 0
0 76161 73349 product 79684 M 0
0 76162 73350 product 79685 M 0
0 76163 73351 product 79686 M 0
0 76215 73403 product 79738 M 0
0 76216 73404 product 79739 M 0
0 76217 73405 product 79740 M 0
0 98846 73119 product 102369 M 0