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 (
    130024, 130025, 130572, 130573, 130574, 
    130575, 130578, 130579, 130582, 130583, 
    130684, 130685, 130686, 130687, 130930, 
    130931, 130932, 130933, 130934, 130935, 
    131010, 131011, 131196, 131197, 131198, 
    131199, 131588, 131589, 131622, 131623, 
    131624, 131625, 131632, 131633, 131766, 
    131767, 131768, 131769, 131770, 131771, 
    131772, 131773, 131816, 131817, 131818, 
    131819, 131824, 131825, 131884, 131885, 
    131966, 131967, 131970, 131971, 132048, 
    132049, 132056, 132057, 132058, 132059, 
    132062, 132063, 132064, 132065, 132090, 
    132091, 132190, 132191, 132294, 132295, 
    132296, 132297, 132298, 132299, 132300, 
    132301, 132356, 132357, 132522, 132523
  ) 
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