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 = 'A' 
  AND cscart_images_links.object_id IN (
    48374, 48373, 48372, 48371, 48370, 48369, 
    48368, 48367, 48366, 48365, 48364, 
    48363, 48362, 48361, 48360, 48359, 
    48358, 48357, 48356, 48355, 48354, 
    48353, 48352, 48351, 70736, 70735, 
    70734, 70733, 48051, 48033, 48032, 
    48031, 47866, 48025, 47884, 47883, 
    47851, 47885, 48028, 47854, 47850, 
    47849, 47813, 47723, 90955, 90954, 
    90953, 90952, 90951, 90950, 90949, 
    47810, 48013, 47836, 47815, 47814, 
    47808, 47689, 47818, 47778, 47777, 
    47776, 47775, 47763, 47762, 47761, 
    47760, 47639, 47744, 47743, 47742, 
    47746, 47604, 47603, 47602, 47601, 
    47600, 47599, 47598, 47597
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00093

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 80 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