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 (
    18905, 18906, 18907, 18908, 18909, 18910, 
    18911, 18912, 18913, 18914, 18915, 
    18916, 18917, 18918, 18919, 18920, 
    18921, 18922, 18923, 18924, 18925, 
    18926, 18927, 18928, 18929, 18930, 
    18931, 18932, 18933, 18934, 18935, 
    18936, 18937, 18938, 18939, 18940, 
    18941, 18942, 18943, 18944, 18945, 
    18946, 18947, 18948, 18949, 18950, 
    18951, 18952, 18953, 18954, 18955, 
    18956, 18957, 18958, 18959, 18960, 
    18961, 18962, 18975, 18976, 18983, 
    18984, 19061, 19062, 19063, 19064, 
    19067, 19068, 19069, 19070, 19071, 
    19072, 19073, 19074, 19075, 19076, 
    19077, 19078, 19079, 19080
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00047

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