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 (
    181198, 181199, 181200, 181201, 181202, 
    181203, 181220, 181221, 181222, 181223, 
    181224, 181225, 181226, 181227, 181228, 
    181229, 181230, 181231, 181232, 181233, 
    181234, 181235, 181236, 181237, 181238, 
    181239, 181240, 181241, 181242, 181243, 
    181244, 181245, 181246, 181247, 181248, 
    181249, 181250, 181251, 181252, 181253, 
    181254, 181255, 181256, 181257, 181258, 
    181259, 181260, 181261, 181268, 181269, 
    181270, 181271, 181274, 181275, 181636, 
    181637, 181638, 181639, 182630, 182631, 
    182632, 182633, 182634, 182635, 182636, 
    182637, 182638, 182639, 182640, 182641, 
    182642, 182643, 182644, 182645, 182646, 
    182647, 182648, 182649, 182650, 182651
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00049

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