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 (
    19089, 19090, 19107, 19108, 19109, 19110, 
    19259, 19260, 19261, 19262, 19263, 
    19264, 19265, 19266, 19267, 19268, 
    19269, 19270, 19271, 19272, 19273, 
    19274, 19275, 19276, 19277, 19278, 
    19279, 19280, 19281, 19282, 19283, 
    19284, 19285, 19286, 19287, 19288, 
    19289, 19290, 19293, 19294, 19295, 
    19296, 19297, 19298, 19299, 19300, 
    19301, 19302, 19353, 19354, 23575, 
    23576, 53039, 53040, 53041, 53042, 
    53043, 53044, 53045, 53046, 53047, 
    53048, 53049, 53050, 53051, 53052, 
    53053, 53054, 53055, 53056, 53057, 
    53058, 53059, 53060, 53061, 53062, 
    53063, 53064, 53065, 53066
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00051

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