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 (
    167858, 167859, 167860, 167861, 167862, 
    167863, 167864, 167865, 167866, 167867, 
    167868, 167869, 167910, 167911, 167912, 
    167913, 167914, 167915, 167988, 167989, 
    167990, 167991, 167992, 167993, 167996, 
    167997, 168000, 168001, 168002, 168003, 
    168004, 168005, 168006, 168007, 168008, 
    168009, 168042, 168043, 168044, 168045, 
    168046, 168047, 168048, 168049, 168050, 
    168051, 168052, 168053, 168366, 168367, 
    168752, 168753, 168796, 168797, 168798, 
    168799, 168800, 168801, 168802, 168803, 
    168804, 168805, 168882, 168883, 168884, 
    168885, 168886, 168887, 168952, 168953, 
    168954, 168955, 168956, 168957, 168958, 
    168959, 168968, 168969, 169172, 169173
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00047

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