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 (
    121810, 121811, 121812, 121813, 121814, 
    121815, 121816, 121817, 121818, 121819, 
    121820, 121821, 121822, 121823, 121824, 
    121825, 121826, 121827, 121828, 121829, 
    121830, 121831, 121832, 121833, 121834, 
    121835, 121860, 121861, 122092, 122093, 
    122094, 122095, 122152, 122153, 122154, 
    122155, 122156, 122157, 122158, 122159, 
    122160, 122161, 122162, 122163, 122164, 
    122165, 122166, 122167, 122168, 122169, 
    122170, 122171, 122172, 122173, 122174, 
    122175, 122176, 122177, 144106, 144107, 
    144108, 144109, 144110, 144111, 144112, 
    144113, 144114, 144115, 144116, 144117, 
    144118, 144119, 144120, 144121, 144122, 
    144123, 144124, 144125, 144126, 144127
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00059

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