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 (
    22376, 
    22377, 
    13994, 
    14010, 
    14002, 
    14033, 
    14024, 
    14005, 
    14025, 
    14021, 
    14028, 
    14003, 
    14011, 
    14012, 
    13998, 
    14000, 
    14032, 
    14027, 
    14034, 
    15545, 
    15546, 
    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, 
    17546, 
    17547, 
    17551, 
    17552, 
    17554, 
    17555, 
    17556, 
    17558, 
    17559, 
    17561, 
    17562, 
    17563, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    22364, 
    22363, 
    22362, 
    22361, 
    22360, 
    22359, 
    22358, 
    22357, 
    22365, 
    22366, 
    22373, 
    22367, 
    22368, 
    22369, 
    22370, 
    22371, 
    22372, 
    13652, 
    13654, 
    13657, 
    22181, 
    22182, 
    22185, 
    22195, 
    22205, 
    22183, 
    22184, 
    22186, 
    22189, 
    22190, 
    22191, 
    22194, 
    22196, 
    22200
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00336

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		133	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
30627	22181	variant_image	26204	V
30628	22182	variant_image	26205	V
30629	22185	variant_image	26206	V
30630	22195	variant_image	26207	V
30631	22205	variant_image	26208	V
30632	22183	variant_image	26209	V
30633	22184	variant_image	26210	V
30634	22186	variant_image	26211	V
30637	22189	variant_image	26214	V
30638	22190	variant_image	26215	V
30641	22194	variant_image	26218	V
30644	22196	variant_image	26221	V
30648	22200	variant_image	26225	V
30653	22191	variant_image	26230	V
30762	22376	variant_image	26340	V
30763	22377	variant_image	26341	V