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 (
    159176, 159177, 159268, 159269, 159272, 
    159273, 159274, 159275, 159326, 159327, 
    159328, 159329, 159350, 159351, 159672, 
    159673, 159674, 159675, 159676, 159677, 
    159678, 159679, 159680, 159681, 159682, 
    159683, 159684, 159685, 159686, 159687, 
    159844, 159845, 159846, 159847, 159848, 
    159849, 159850, 159851, 159852, 159853, 
    159854, 159855, 159856, 159857, 159858, 
    159859, 159860, 159861, 159862, 159863, 
    159864, 159865, 159866, 159867, 159882, 
    159883, 159884, 159885, 159886, 159887, 
    159888, 159889, 159890, 159891, 159934, 
    159935, 159936, 159937, 159946, 159947, 
    159950, 159951, 159954, 159955, 159956, 
    159957, 159958, 159959, 160002, 160003
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00072

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