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 (
    58722, 59121, 58587, 58854, 58778, 58646, 
    58357, 57734, 58959, 58958, 58961, 
    58952, 58951, 58950, 58949, 58948, 
    58947, 58946, 58945, 58944, 58943, 
    58942, 58941, 58940, 58939, 58938, 
    58937, 58936, 58935, 58934, 58933, 
    58932, 58931, 58930, 58929, 58928, 
    58927, 58926, 58925, 58924
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00073

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 59270 57734 product 62793 M 0
0 59893 58357 product 63416 M 0
0 60119 58587 product 63642 M 0
0 60180 58646 product 63703 M 0
0 60256 58722 product 63779 M 0
0 60312 58778 product 63835 M 0
0 60390 58854 product 63913 M 0
0 60460 58924 product 63983 M 0
0 60461 58925 product 63984 M 0
0 60462 58926 product 63985 M 0
0 60463 58927 product 63986 M 0
0 60464 58928 product 63987 M 0
0 60465 58929 product 63988 M 0
0 60466 58930 product 63989 M 0
0 60467 58931 product 63990 M 0
0 60468 58932 product 63991 M 0
0 60469 58933 product 63992 M 0
0 60470 58934 product 63993 M 0
0 60471 58935 product 63994 M 0
0 60472 58936 product 63995 M 0
0 60473 58937 product 63996 M 0
0 60474 58938 product 63997 M 0
0 60475 58939 product 63998 M 0
0 60476 58940 product 63999 M 0
0 60477 58941 product 64000 M 0
0 60478 58942 product 64001 M 0
0 60479 58943 product 64002 M 0
0 60480 58944 product 64003 M 0
0 60481 58945 product 64004 M 0
0 60482 58946 product 64005 M 0
0 60483 58947 product 64006 M 0
0 60484 58948 product 64007 M 0
0 60485 58949 product 64008 M 0
0 60486 58950 product 64009 M 0
0 60487 58951 product 64010 M 0
0 60488 58952 product 64011 M 0
0 60494 58958 product 64017 M 0
0 60496 58961 product 64019 M 0
0 60524 58959 product 64047 M 0
0 60657 59121 product 64180 M 0