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 (
    69444, 
    69445, 
    69446, 
    69447, 
    69464, 
    69465, 
    69476, 
    69477, 
    69528, 
    69529, 
    69548, 
    69549, 
    69552, 
    69553, 
    69560, 
    69561, 
    69562, 
    69563, 
    69564, 
    69565, 
    69566, 
    69567, 
    69568, 
    69569, 
    69570, 
    69571, 
    69572, 
    69573, 
    69574, 
    69575, 
    69576, 
    69577, 
    69578, 
    69579, 
    69580, 
    69581, 
    69582, 
    69583, 
    69586, 
    69587, 
    69590, 
    69591, 
    69608, 
    69609, 
    69614, 
    69615, 
    69620, 
    69621, 
    69636, 
    69637, 
    69638, 
    69639, 
    69640, 
    69641, 
    69764, 
    69765, 
    69784, 
    69785, 
    69796, 
    69797, 
    69798, 
    69799, 
    69806, 
    69807, 
    69814, 
    69815, 
    69816, 
    69817, 
    69818, 
    69819, 
    69820, 
    69821, 
    69824, 
    69825, 
    69826, 
    69827, 
    69832, 
    69833, 
    69834, 
    69835, 
    69842, 
    69843, 
    69844, 
    69845, 
    69922, 
    69923, 
    69924, 
    69925, 
    69926, 
    69927, 
    69934, 
    69935, 
    69936, 
    69937, 
    69952, 
    69953, 
    69954, 
    69955, 
    69956, 
    69957, 
    69970, 
    69971, 
    69992, 
    69993, 
    69994, 
    69995, 
    69996, 
    69997, 
    70080, 
    70081, 
    70662, 
    70663, 
    70826, 
    70827, 
    70834, 
    70835, 
    70836, 
    70837, 
    70852, 
    70853, 
    71130, 
    71131, 
    71132, 
    71133, 
    71134, 
    71135, 
    71136, 
    71137, 
    71142, 
    71143, 
    71144, 
    71145, 
    71296, 
    71297, 
    71470, 
    71471, 
    150202, 
    150203, 
    150210, 
    150211, 
    150230, 
    150231, 
    171772, 
    171773, 
    171774, 
    171775, 
    171776, 
    171777, 
    171778, 
    171779, 
    171780, 
    171781, 
    171782, 
    171783, 
    171784, 
    171785, 
    171786, 
    171787, 
    171788, 
    171789
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00116

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