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 (
    21886, 
    21887, 
    18539, 
    18544, 
    18551, 
    18542, 
    18543, 
    18540, 
    18541, 
    18545, 
    18546, 
    18547, 
    18548, 
    18549, 
    18550, 
    18552, 
    18553, 
    18554, 
    18555, 
    18556, 
    18563, 
    18557, 
    18564, 
    18558, 
    18565, 
    18559, 
    18566, 
    18560, 
    18567, 
    18561, 
    18562, 
    18568, 
    18574, 
    18569, 
    18575, 
    18570, 
    18576, 
    18571, 
    18577, 
    18572, 
    18573, 
    18578, 
    18579, 
    18580, 
    18584, 
    18585, 
    18581, 
    18586, 
    18582, 
    18583, 
    18587, 
    18592, 
    18588, 
    18593, 
    18589, 
    18594, 
    18590, 
    18591, 
    21968, 
    21969, 
    21970, 
    21971, 
    21972, 
    21973, 
    21974, 
    21975, 
    21977, 
    21976, 
    21978, 
    21979, 
    21980, 
    21981, 
    21982, 
    21983, 
    21984, 
    21985, 
    21986, 
    21987, 
    21988, 
    21989, 
    21990, 
    21991, 
    21992, 
    21993, 
    21994, 
    21997, 
    21998, 
    21999, 
    22000, 
    22001, 
    22002, 
    22003, 
    22004, 
    22008, 
    22009, 
    22010, 
    22011, 
    22012, 
    22013, 
    22016, 
    22017, 
    22018, 
    22019, 
    22020, 
    22021, 
    14038, 
    14039, 
    15309, 
    14040, 
    14041, 
    14215, 
    14042, 
    14043, 
    14044, 
    14045, 
    14046, 
    14047, 
    15373, 
    14048, 
    14049, 
    14050, 
    19534, 
    19535, 
    21894, 
    21895, 
    23900, 
    23901, 
    15153, 
    15154, 
    15156, 
    16187, 
    16188, 
    16189, 
    16190, 
    16191, 
    23887, 
    23888, 
    23886, 
    23885, 
    23891, 
    23890, 
    23889, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    21870, 
    21871, 
    21872, 
    21873, 
    21874, 
    21875, 
    21876, 
    21877, 
    21878, 
    21879, 
    21880, 
    21881, 
    21882, 
    21883, 
    21884, 
    21885, 
    21897, 
    21898, 
    21900, 
    21901, 
    21896, 
    21902, 
    21904, 
    21903, 
    21905, 
    21906, 
    21907, 
    21908, 
    21910, 
    21911, 
    21909, 
    21899, 
    14859, 
    14860, 
    14863, 
    14879, 
    14889, 
    14861, 
    14862, 
    14864, 
    14867, 
    14868, 
    14869, 
    14872, 
    14880, 
    14884
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00443

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		219	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
30373	21870	variant_image	25950	V
30374	21871	variant_image	25951	V
30375	21872	variant_image	25952	V
30376	21873	variant_image	25953	V
30377	21874	variant_image	25954	V
30378	21875	variant_image	25955	V
30379	21876	variant_image	25956	V
30380	21877	variant_image	25957	V
30381	21878	variant_image	25958	V
30382	21879	variant_image	25959	V
30383	21880	variant_image	25960	V
30384	21881	variant_image	25961	V
30385	21882	variant_image	25962	V
30386	21883	variant_image	25963	V
30387	21884	variant_image	25964	V
30388	21885	variant_image	25965	V
30399	21886	variant_image	25976	V
30400	21887	variant_image	25977	V
30531	21897	variant_image	26108	V
30532	21898	variant_image	26109	V
30533	21900	variant_image	26110	V
30534	21901	variant_image	26111	V
30535	21896	variant_image	26112	V
30536	21902	variant_image	26113	V
30537	21904	variant_image	26114	V
30538	21903	variant_image	26115	V
30539	21905	variant_image	26116	V
30540	21906	variant_image	26117	V
30541	21907	variant_image	26118	V
30542	21899	variant_image	26119	V
30543	21908	variant_image	26120	V
30544	21910	variant_image	26121	V
30545	21911	variant_image	26122	V
30546	21909	variant_image	26123	V
30681	14859	variant_image	26259	V
30682	14860	variant_image	26260	V
30683	14863	variant_image	26261	V
30684	14879	variant_image	26262	V
30685	14889	variant_image	26263	V
30686	14861	variant_image	26264	V
30687	14862	variant_image	26265	V
30688	14864	variant_image	26266	V
30691	14867	variant_image	26269	V
30692	14868	variant_image	26270	V
30693	14869	variant_image	26271	V
30696	14872	variant_image	26274	V
30699	14880	variant_image	26277	V
30703	14884	variant_image	26281	V