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.detailed_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.00087

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.detailed_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 Circleaur_Saw.jpg 1400 1400 59270 57734 product 62793 M 0 62793
0 5054282969697.jpg 1000 1000 59893 58357 product 63416 M 0 63416
0 5054282988674.jpg 1000 1000 60119 58587 product 63642 M 0 63642
0 PDHH069.jpg 1400 1400 60180 58646 product 63703 M 0 63703
0 5054282949293.jpg 1000 1000 60256 58722 product 63779 M 0 63779
0 Fireball_Recordings_266.jpg 1400 1400 60312 58778 product 63835 M 0 63835
0 Vicious_Circle_Recordings_PKR7_updated_Artwork_(Higher).psd.jpg 1400 1400 60390 58854 product 63913 M 0 63913
0 volume6_4y1t-29.jpg 1400 1400 60460 58924 product 63983 M 0 63983
0 volume6_y6vu-f9.jpg 1400 1400 60461 58925 product 63984 M 0 63984
0 volume6_bahg-9i.jpg 1400 1400 60462 58926 product 63985 M 0 63985
0 volume6_9fr8-mm.jpg 1400 1400 60463 58927 product 63986 M 0 63986
0 volume6_d10o-7r.jpg 1400 1400 60464 58928 product 63987 M 0 63987
0 volume6_5are-5m.jpg 1400 1400 60465 58929 product 63988 M 0 63988
0 volume6_jm6x-o6.jpg 1400 1400 60466 58930 product 63989 M 0 63989
0 volume6_zdx5-op.jpg 1400 1400 60467 58931 product 63990 M 0 63990
0 volume6_tysy-79.jpg 1400 1400 60468 58932 product 63991 M 0 63991
0 volume6_r7vq-cg.jpg 1400 1400 60469 58933 product 63992 M 0 63992
0 volume6_bx44-wx.jpg 1400 1400 60470 58934 product 63993 M 0 63993
0 volume6_hjq8-qm.jpg 1400 1400 60471 58935 product 63994 M 0 63994
0 volume6_qa71-8c.jpg 1400 1400 60472 58936 product 63995 M 0 63995
0 volume6_5adm-t4.jpg 1400 1400 60473 58937 product 63996 M 0 63996
0 volume6_kg5a-rc.jpg 1400 1400 60474 58938 product 63997 M 0 63997
0 volume6_fgtl-r7.jpg 1400 1400 60475 58939 product 63998 M 0 63998
0 volume6_x17h-ic.jpg 1400 1400 60476 58940 product 63999 M 0 63999
0 volume6.jpg 1400 1400 60477 58941 product 64000 M 0 64000
0 volume6_tl85-od.jpg 1400 1400 60478 58942 product 64001 M 0 64001
0 volume6_dxst-i9.jpg 1400 1400 60479 58943 product 64002 M 0 64002
0 volume6_xi3v-6r.jpg 1400 1400 60480 58944 product 64003 M 0 64003
0 volume6_rykk-wf.jpg 1400 1400 60481 58945 product 64004 M 0 64004
0 volume6_1zi1-i6.jpg 1400 1400 60482 58946 product 64005 M 0 64005
0 volume6_w1dt-5d.jpg 1400 1400 60483 58947 product 64006 M 0 64006
0 volume6_0tt2-tc.jpg 1400 1400 60484 58948 product 64007 M 0 64007
0 volume6_auq6-w3.jpg 1400 1400 60485 58949 product 64008 M 0 64008
0 volume6_i67j-z1.jpg 1400 1400 60486 58950 product 64009 M 0 64009
0 volume6_2dgd-76.jpg 1400 1400 60487 58951 product 64010 M 0 64010
0 volume6_7njq-ur.jpg 1400 1400 60488 58952 product 64011 M 0 64011
0 Bigboogies_Vox_&_Go_-_Keep_It_Up_(Original).jpg 800 800 60494 58958 product 64017 M 0 64017
0 IOD034.jpg 900 900 60496 58961 product 64019 M 0 64019
0 Bigboogies_Vox_&_Go_-_Keep_It_Up_(BW_Venks)_ready.jpg 800 800 60524 58959 product 64047 M 0 64047
0 DD111.jpg 1000 1000 60657 59121 product 64180 M 0 64180