Sandbox

SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  cscart_images.image_id as images_image_id 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images_links.detailed_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 = 'fr' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    24304, 
    24305, 
    15775, 
    15776, 
    21889, 
    21888, 
    22389, 
    22390, 
    22391, 
    22392, 
    22393, 
    22394, 
    22395, 
    22396, 
    22397, 
    22451, 
    22452, 
    22474, 
    22475, 
    20790, 
    20791, 
    20792, 
    20793, 
    20794, 
    20795, 
    20796, 
    20797, 
    20798, 
    20799, 
    20800, 
    20801, 
    20802, 
    20803, 
    20804, 
    20805, 
    20806, 
    20807, 
    20808, 
    20809, 
    20810, 
    21010, 
    21011, 
    21012, 
    21013, 
    21014, 
    21015, 
    21016, 
    21017, 
    21018, 
    21019, 
    21022, 
    21023, 
    21024, 
    21025, 
    21026, 
    23833, 
    21028, 
    21029, 
    23834, 
    21318, 
    21322, 
    21323, 
    21324, 
    21325, 
    21326, 
    21327, 
    23818, 
    21406, 
    21407, 
    21409, 
    21410, 
    21411, 
    21412, 
    21413, 
    21414, 
    21415, 
    21418, 
    21419, 
    21421, 
    21422, 
    19588, 
    19590, 
    19591, 
    19592, 
    19593, 
    19594, 
    19589, 
    21278, 
    21280, 
    21281, 
    21282, 
    21287, 
    21388, 
    21390, 
    21391, 
    21392, 
    21393, 
    21397, 
    15104, 
    15105, 
    15553, 
    15106, 
    15107, 
    15554, 
    15108, 
    15109, 
    15110, 
    15111, 
    15112, 
    15113, 
    15114, 
    15115, 
    22398, 
    22399, 
    22400, 
    22401, 
    22402, 
    22403, 
    22404, 
    22405, 
    22406, 
    22407, 
    22408, 
    22409, 
    22410, 
    22411, 
    22412, 
    22459, 
    22460, 
    22462, 
    22463, 
    22465, 
    22466, 
    22467, 
    22469, 
    22470, 
    22471, 
    22472, 
    22473, 
    22442, 
    22443, 
    22444
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00314

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		142	Using index condition; Using filesort
1	SIMPLE	cscart_images	eq_ref	PRIMARY	PRIMARY	3	mahm3t_cs443.cscart_images_links.detailed_id	1	Using where
1	SIMPLE	cscart_common_descriptions	eq_ref	PRIMARY	PRIMARY	107	mahm3t_cs443.cscart_images.image_id,const,const	1	Using where

Result

pair_id	object_id	object_type	image_id	type
27592	15775	variant_image	23167	V
27593	15776	variant_image	23168	V
30529	21888	variant_image	26106	V
30530	21889	variant_image	26107	V
30789	22396	variant_image	26367	V
30790	22397	variant_image	26368	V