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 (
    178196, 178197, 178198, 178199, 178200, 
    178201, 178202, 178203, 178204, 178205, 
    178206, 178207, 178208, 178209, 178210, 
    178211, 178212, 178213, 178214, 178215, 
    178340, 178341, 178342, 178343, 178344, 
    178345, 178346, 178347, 178348, 178349, 
    178350, 178351, 178352, 178353, 178354, 
    178355, 178356, 178357, 178358, 178359, 
    178360, 178361, 178362, 178363, 178460, 
    178461, 178634, 178635, 178636, 178637, 
    178638, 178639, 178640, 178641, 180204, 
    180205, 180206, 180207, 180208, 180209, 
    180210, 180211, 180212, 180213, 180214, 
    180215, 180216, 180217, 180218, 180219, 
    180220, 180221, 180222, 180223, 180224, 
    180225, 180226, 180227, 180228, 180229
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00054

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