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 = 'de' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    22376, 
    22377, 
    14038, 
    14039, 
    15309, 
    14040, 
    14041, 
    14215, 
    14042, 
    14043, 
    14044, 
    14045, 
    14046, 
    14047, 
    15373, 
    14048, 
    14049, 
    14050, 
    23941, 
    23944, 
    23945, 
    23966, 
    23946, 
    23947, 
    23942, 
    23943, 
    15104, 
    15105, 
    15553, 
    15106, 
    15107, 
    15554, 
    15108, 
    15109, 
    15110, 
    15111, 
    15112, 
    15113, 
    15114, 
    15115, 
    22364, 
    22363, 
    22362, 
    22361, 
    22360, 
    22359, 
    22358, 
    22357, 
    22365, 
    22366, 
    22373, 
    22367, 
    22368, 
    22369, 
    22370, 
    22371, 
    22372, 
    23928, 
    23929, 
    23930, 
    23931, 
    23932, 
    23933, 
    23934, 
    23935, 
    23937, 
    23938, 
    23939, 
    23940, 
    23948, 
    23949, 
    23950, 
    23951, 
    23952, 
    23953, 
    23954, 
    23955, 
    23956, 
    23957, 
    23958, 
    23959, 
    23960, 
    23961, 
    23962, 
    23963, 
    23964, 
    23965, 
    23984, 
    23983, 
    23981, 
    23980, 
    23982, 
    23979, 
    23990, 
    23989, 
    23988, 
    23987, 
    23986, 
    23985, 
    20566, 
    20567, 
    20568, 
    20569, 
    20570, 
    20571, 
    20572, 
    20573, 
    20574, 
    20576, 
    20577, 
    20578, 
    20579, 
    20581, 
    20582, 
    20583, 
    20584, 
    20585, 
    20586, 
    20587, 
    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.00323

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		138	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
32054	23941	variant_image	27632	V
32055	23942	variant_image	27633	V
32056	23943	variant_image	27634	V
32057	23944	variant_image	27635	V
32058	23945	variant_image	27636	V
32059	23946	variant_image	27637	V
32060	23947	variant_image	27638	V
32075	23966	variant_image	27653	V