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.image_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 (
    137162, 137163, 137164, 137165, 137166, 
    137167, 137168, 137169, 137170, 137171, 
    137172, 137173, 137174, 137175, 137176, 
    137177, 137178, 137179, 137180, 137181, 
    137182, 137183, 137184, 137185, 137186, 
    137187, 137188, 137189, 137190, 137191, 
    137192, 137193, 137194, 137195, 137196, 
    137197, 137198, 137199, 137200, 137201, 
    137250, 137251, 137338, 137339, 137436, 
    137437, 137438, 137439, 137562, 137563, 
    137564, 137565, 137576, 137577, 137768, 
    137769, 137966, 137967, 137968, 137969, 
    137970, 137971, 137972, 137973, 137974, 
    137975, 137976, 137977, 137978, 137979, 
    137980, 137981, 137982, 137983, 137984, 
    137985, 137986, 137987, 137988, 137989
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00061

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.image_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where