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 (
    20619, 20620, 20621, 20622, 20623, 20624, 
    20625, 20626, 20627, 20628, 20629, 
    20630, 20631, 20632, 20633, 20634, 
    20637, 20638, 20639, 20640, 20641, 
    20642, 20643, 20644, 20647, 20648, 
    20649, 20650, 20651, 20652, 20653, 
    20654, 20655, 20656, 20657, 20658, 
    20659, 20660, 20661, 20662, 20687, 
    20688, 20719, 20720, 20743, 20744, 
    20757, 20758, 20761, 20762, 20763, 
    20764, 20769, 20770, 20773, 20774, 
    20777, 20778, 20889, 20890, 20903, 
    20904, 20927, 20928, 20929, 20930, 
    20949, 20950, 20951, 20952, 36941, 
    36942, 36955, 36956, 67816, 67817, 
    143298, 143299, 143300, 143301
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00050

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