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 (
    87352, 
    87353, 
    87354, 
    87355, 
    87356, 
    87357, 
    87358, 
    87359, 
    87376, 
    87377, 
    87378, 
    87379, 
    87380, 
    87381, 
    87382, 
    87383, 
    87406, 
    87407, 
    87414, 
    87415, 
    87416, 
    87417, 
    87418, 
    87419, 
    87420, 
    87421, 
    87422, 
    87423, 
    87424, 
    87425, 
    87426, 
    87427, 
    87428, 
    87429, 
    87430, 
    87431, 
    87432, 
    87433, 
    87434, 
    87435, 
    87436, 
    87437, 
    87438, 
    87439, 
    87440, 
    87441, 
    87442, 
    87443, 
    87450, 
    87451, 
    87452, 
    87453, 
    87454, 
    87455, 
    87486, 
    87487, 
    87516, 
    87517, 
    87518, 
    87519, 
    87542, 
    87543, 
    87544, 
    87545, 
    87546, 
    87547, 
    87552, 
    87553, 
    87554, 
    87555, 
    87556, 
    87557, 
    87628, 
    87629, 
    87630, 
    87631, 
    87646, 
    87647, 
    87648, 
    87649, 
    87668, 
    87669, 
    87670, 
    87671, 
    87672, 
    87673, 
    87720, 
    87721, 
    87722, 
    87723, 
    87748, 
    87749, 
    87754, 
    87755, 
    87756, 
    87757, 
    87758, 
    87759, 
    87872, 
    87873, 
    87926, 
    87927, 
    87956, 
    87957, 
    87962, 
    87963, 
    87964, 
    87965, 
    87974, 
    87975, 
    88050, 
    88051, 
    88052, 
    88053, 
    88054, 
    88055, 
    88056, 
    88057, 
    88158, 
    88159, 
    88160, 
    88161, 
    88168, 
    88169, 
    88178, 
    88179, 
    88256, 
    88257, 
    88258, 
    88259, 
    88260, 
    88261, 
    88262, 
    88263, 
    88264, 
    88265, 
    88266, 
    88267, 
    88268, 
    88269, 
    88270, 
    88271, 
    88272, 
    88273, 
    88274, 
    88275, 
    88276, 
    88277, 
    88278, 
    88279, 
    88280, 
    88281, 
    88282, 
    88283, 
    88492, 
    88493, 
    88822, 
    88823, 
    89152, 
    89153
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00082

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