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 (
    22807, 22808, 22809, 24304, 24305, 15775, 
    15776, 21889, 21888, 22389, 22390, 
    22391, 22392, 22393, 22394, 22395, 
    22396, 22397, 22801, 22802, 22803, 
    22804, 22805, 22806, 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
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00146

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