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 (
    73564, 73565, 130944, 130945, 131628, 
    131629, 131630, 131631, 132916, 132917, 
    132932, 132933, 133164, 133165, 133194, 
    133195, 133250, 133251, 133292, 133293, 
    133294, 133295, 133298, 133299, 133300, 
    133301, 133346, 133347, 133396, 133397, 
    133398, 133399, 133492, 133493, 133506, 
    133507, 133508, 133509, 133518, 133519, 
    133572, 133573, 133574, 133575, 133622, 
    133623, 133624, 133625, 133792, 133793, 
    133794, 133795, 133844, 133845, 133898, 
    133899, 134018, 134019, 134086, 134087, 
    134088, 134089, 134388, 134389, 134390, 
    134391, 135272, 135273, 136502, 136503, 
    136506, 136507, 136508, 136509, 136636, 
    136637, 137000, 137001, 137010, 137011
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00058

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