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 (
    108610, 108611, 108612, 108613, 108614, 
    108615, 109588, 109589, 109594, 109595, 
    110770, 110771, 110844, 110845, 110976, 
    110977, 111330, 111331, 111456, 111457, 
    111458, 111459, 111460, 111461, 111686, 
    111687, 111688, 111689, 111828, 111829, 
    111942, 111943, 112010, 112011, 112092, 
    112093, 112094, 112095, 112108, 112109, 
    112318, 112319, 112556, 112557, 112610, 
    112611, 112780, 112781, 112996, 112997, 
    113068, 113069, 113070, 113071, 113074, 
    113075, 113096, 113097, 113098, 113099, 
    113100, 113101, 113102, 113103, 113104, 
    113105, 113106, 113107, 113108, 113109, 
    113110, 113111, 113112, 113113, 113114, 
    113115, 113116, 113117, 113118, 113119
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00055

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