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 (
    83926, 
    83927, 
    83972, 
    83973, 
    84106, 
    84107, 
    84148, 
    84149, 
    84156, 
    84157, 
    84158, 
    84159, 
    84170, 
    84171, 
    84172, 
    84173, 
    84176, 
    84177, 
    84180, 
    84181, 
    84296, 
    84297, 
    84322, 
    84323, 
    84324, 
    84325, 
    84374, 
    84375, 
    84376, 
    84377, 
    84378, 
    84379, 
    84380, 
    84381, 
    84382, 
    84383, 
    84384, 
    84385, 
    84386, 
    84387, 
    84388, 
    84389, 
    84390, 
    84391, 
    84408, 
    84409, 
    84410, 
    84411, 
    84412, 
    84413, 
    84414, 
    84415, 
    84416, 
    84417, 
    84418, 
    84419, 
    84420, 
    84421, 
    84422, 
    84423, 
    84424, 
    84425, 
    84426, 
    84427, 
    84448, 
    84449, 
    84466, 
    84467, 
    84474, 
    84475, 
    84476, 
    84477, 
    84482, 
    84483, 
    84486, 
    84487, 
    84558, 
    84559, 
    84560, 
    84561, 
    84562, 
    84563, 
    84564, 
    84565, 
    84568, 
    84569, 
    84572, 
    84573, 
    84574, 
    84575, 
    84592, 
    84593, 
    84594, 
    84595, 
    84596, 
    84597, 
    84598, 
    84599, 
    84600, 
    84601, 
    84602, 
    84603, 
    84604, 
    84605, 
    84606, 
    84607, 
    84678, 
    84679, 
    84748, 
    84749, 
    84750, 
    84751, 
    84752, 
    84753, 
    84754, 
    84755, 
    84756, 
    84757, 
    84758, 
    84759, 
    84760, 
    84761, 
    84762, 
    84763, 
    84764, 
    84765, 
    84766, 
    84767, 
    84768, 
    84769, 
    84770, 
    84771, 
    84772, 
    84773, 
    84774, 
    84775, 
    84776, 
    84777, 
    84778, 
    84779, 
    84780, 
    84781, 
    84782, 
    84783, 
    84784, 
    84785, 
    84786, 
    84787, 
    84788, 
    84789, 
    84790, 
    84791, 
    84792, 
    84793, 
    84794, 
    84795, 
    84796, 
    84797, 
    91474, 
    91475
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00108

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