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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    22807, 22808, 22809, 23288, 23289, 24187, 
    24184, 24185, 24186, 24188, 24189, 
    24190, 24191, 22801, 22802, 22803, 
    22804, 22805, 22806, 23234, 23233, 
    23235, 23236, 23237, 23238, 23255, 
    23256, 23251, 23252, 23284, 23285, 
    23286, 23287, 23208, 23209, 23210, 
    23211, 23212, 23213, 23214, 23215, 
    23216, 23217, 23218, 23219, 23220, 
    23221, 23222, 23223, 23224, 23225, 
    23226, 23227, 23228, 23229, 23230, 
    23231, 23232, 23257, 23258, 23259, 
    23260, 23261, 23262, 23263, 23264, 
    23265, 23266, 23267, 23268, 23269, 
    23270, 23271, 23272, 23273, 23274, 
    23275, 23276, 23277, 23278, 23279, 
    23280, 23281
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00209

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		84	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
30951	23233	variant_image	26529	V
30952	23234	variant_image	26530	V
30953	23235	variant_image	26531	V
30954	23236	variant_image	26532	V
30955	23237	variant_image	26533	V
30956	23238	variant_image	26534	V