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 = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    119936, 119937, 119938, 119939, 119940, 
    119941, 119942, 119943, 119944, 119945, 
    119946, 119947, 119948, 119949, 119950, 
    119951, 120092, 120093, 120094, 120095, 
    120152, 120153, 120568, 120569, 120730, 
    120731, 120732, 120733, 120734, 120735, 
    120736, 120737, 120738, 120739, 120740, 
    120741, 120742, 120743, 120744, 120745, 
    120746, 120747, 120748, 120749, 120750, 
    120751, 120752, 120753, 120826, 120827, 
    120884, 120885, 120892, 120893, 120894, 
    120895, 120908, 120909, 120912, 120913, 
    120922, 120923, 120928, 120929, 120940, 
    120941, 120948, 120949, 121074, 121075, 
    121076, 121077, 121078, 121079, 121080, 
    121081, 121082, 121083, 121500, 121501
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00077

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