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 (
    178756, 178757, 178758, 178759, 178760, 
    178761, 178818, 178819, 178844, 178845, 
    178846, 178847, 178848, 178849, 178850, 
    178851, 178852, 178853, 178854, 178855, 
    178856, 178857, 178858, 178859, 179292, 
    179293, 180338, 180339, 180584, 180585, 
    180586, 180587, 180588, 180589, 180590, 
    180591, 180592, 180593, 180594, 180595, 
    180596, 180597, 180598, 180599, 180600, 
    180601, 180602, 180603, 180604, 180605, 
    180606, 180607, 180608, 180609, 180610, 
    180611, 180612, 180613, 180614, 180615, 
    180616, 180617, 180618, 180619, 180620, 
    180621, 180622, 180623, 180624, 180625, 
    180626, 180627, 180628, 180629, 180630, 
    180631, 180632, 180633
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00056

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 78 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