Sandbox

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 (
    85122, 
    85123, 
    85124, 
    85125, 
    85238, 
    85239, 
    85240, 
    85241, 
    85300, 
    85301, 
    85336, 
    85337, 
    85340, 
    85341, 
    85342, 
    85343, 
    85344, 
    85345, 
    85346, 
    85347, 
    85348, 
    85349, 
    85380, 
    85381, 
    85522, 
    85523, 
    85540, 
    85541, 
    85602, 
    85603, 
    85608, 
    85609, 
    85610, 
    85611, 
    85612, 
    85613, 
    85628, 
    85629, 
    85630, 
    85631, 
    85632, 
    85633, 
    85646, 
    85647, 
    85648, 
    85649, 
    85650, 
    85651, 
    85652, 
    85653, 
    85654, 
    85655, 
    85662, 
    85663, 
    85664, 
    85665, 
    85666, 
    85667, 
    85668, 
    85669, 
    85670, 
    85671, 
    85676, 
    85677, 
    85678, 
    85679, 
    85686, 
    85687, 
    85688, 
    85689, 
    85690, 
    85691, 
    85728, 
    85729, 
    85738, 
    85739, 
    85880, 
    85881, 
    85882, 
    85883, 
    85884, 
    85885, 
    85886, 
    85887, 
    85888, 
    85889, 
    85890, 
    85891, 
    85892, 
    85893, 
    85894, 
    85895, 
    85896, 
    85897, 
    85898, 
    85899, 
    85900, 
    85901, 
    85902, 
    85903, 
    85904, 
    85905, 
    85906, 
    85907, 
    85908, 
    85909, 
    85910, 
    85911, 
    85912, 
    85913, 
    85914, 
    85915, 
    85916, 
    85917, 
    85918, 
    85919, 
    85920, 
    85921, 
    85922, 
    85923, 
    85924, 
    85925, 
    85926, 
    85927, 
    85928, 
    85929, 
    85930, 
    85931, 
    85932, 
    85933, 
    85934, 
    85935, 
    85936, 
    85937, 
    85938, 
    85939, 
    85940, 
    85941, 
    85942, 
    85943, 
    85944, 
    85945, 
    85946, 
    85947, 
    85948, 
    85949, 
    85950, 
    85951, 
    86070, 
    86071, 
    86450, 
    86451, 
    86452, 
    86453, 
    86520, 
    86521, 
    86534, 
    86535, 
    86932, 
    86933
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00073

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		160	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