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 (
    13248, 13270, 13249, 13271, 13250, 13272, 
    13251, 13273, 13252, 13274, 13253, 
    13275, 13254, 13276, 13255, 13277, 
    13256, 13278, 13257, 13279, 13258, 
    13280, 13882, 13260, 13282, 13261, 
    13283, 13262, 13284, 13263, 13285, 
    13264, 13286, 13265, 13287, 13266, 
    13288, 13267, 13289, 13268, 13290, 
    13269, 13291, 14038, 14039, 15309, 
    14040, 14041, 14215, 14042, 14043, 
    14044, 14045, 14046, 14047, 15373, 
    14048, 14049, 14050, 17546, 17547, 
    17551, 17552, 17554, 17555, 17556, 
    17558, 17559, 17561, 17562, 17563, 
    15153, 15154, 15156
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00204

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		75	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
26151	15153	variant_image	21726	V
26152	15154	variant_image	21727	V
26157	15156	variant_image	21732	V