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 (
    121172, 121173, 121174, 121175, 121176, 
    121177, 121452, 121453, 126018, 126019, 
    126020, 126021, 126022, 126023, 126024, 
    126025, 126174, 126175, 126176, 126177, 
    126178, 126179, 126180, 126181, 126182, 
    126183, 126184, 126185, 126186, 126187, 
    126188, 126189, 126190, 126191, 126192, 
    126193, 126328, 126329, 126340, 126341, 
    126346, 126347, 126438, 126439, 126450, 
    126451, 126552, 126553, 126558, 126559, 
    126766, 126767, 126768, 126769, 126906, 
    126907, 127034, 127035, 127250, 127251, 
    127264, 127265, 127338, 127339, 127340, 
    127341, 127342, 127343, 127344, 127345, 
    127348, 127349, 127350, 127351, 127534, 
    127535, 127676, 127677, 127678, 127679
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00052

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