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 = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    20947, 20948, 20953, 20954, 20955, 20956, 
    20957, 20958, 20959, 20960, 20961, 
    20962, 20963, 20964, 20965, 20966, 
    20967, 20968, 20969, 20970, 20971, 
    20972, 20973, 20974, 20975, 20976, 
    20977, 20978, 20979, 20980, 20983, 
    20984, 20999, 21000, 21009, 21010, 
    21023, 21024, 21025, 21026, 21029, 
    21030, 21111, 21112, 21119, 21120, 
    21121, 21122, 21123, 21124, 21129, 
    21130, 21181, 21182, 21187, 21188, 
    21189, 21190, 21191, 21192, 21277, 
    21278, 21279, 21280, 21345, 21346, 
    21347, 21348, 21349, 21350, 21351, 
    21352, 73720, 73721, 73722, 73723, 
    73724, 73725, 73726, 73727
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00044

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.detailed_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where