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.image_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, 
    13994, 
    14010, 
    14002, 
    14033, 
    14024, 
    14005, 
    14025, 
    14021, 
    14028, 
    14003, 
    14011, 
    14012, 
    13998, 
    14000, 
    14032, 
    14027, 
    14034, 
    15152, 
    15151, 
    14038, 
    14039, 
    15309, 
    14040, 
    14041, 
    14215, 
    14042, 
    14043, 
    14044, 
    14045, 
    14046, 
    14047, 
    15373, 
    14048, 
    14049, 
    14050, 
    15746, 
    15747, 
    23381, 
    23382, 
    23379, 
    23380, 
    23384, 
    23385, 
    23386, 
    23387, 
    23388, 
    23389, 
    23391, 
    23392, 
    23393, 
    23394, 
    23395, 
    23402, 
    23396, 
    23403, 
    23397, 
    23404, 
    23398, 
    23405, 
    23399, 
    23406, 
    23400, 
    23401, 
    23407, 
    23413, 
    23408, 
    23414, 
    23409, 
    23415, 
    23410, 
    23416, 
    23411, 
    23412, 
    23417, 
    23418, 
    23419, 
    23423, 
    23424, 
    23420, 
    23425, 
    23421, 
    23422, 
    23426, 
    23431, 
    23427, 
    23432, 
    23428, 
    23433, 
    23429, 
    23430, 
    20386, 
    20388, 
    20390, 
    20724, 
    20725, 
    20726, 
    20728, 
    20729, 
    20730, 
    20731, 
    20732, 
    20733, 
    20738, 
    20739, 
    20742, 
    20743, 
    20834, 
    20835, 
    20836, 
    20837, 
    20838, 
    20839, 
    20840, 
    20841, 
    20842, 
    20843, 
    20844, 
    20845, 
    20846, 
    20847, 
    20848, 
    20849, 
    20850, 
    20851, 
    20852, 
    20853, 
    20854, 
    20988, 
    20989, 
    20990, 
    20991, 
    20992, 
    20993, 
    20994, 
    20995, 
    20996, 
    20997, 
    21000, 
    21001, 
    21002, 
    21003, 
    21004, 
    21032, 
    21033, 
    21034, 
    21036, 
    21037, 
    21038, 
    21039, 
    21040, 
    21041, 
    21045, 
    21046, 
    21047, 
    21050, 
    21051, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    23824, 
    21344, 
    23825, 
    21346, 
    21347, 
    21348, 
    23826, 
    21353, 
    21832, 
    21833, 
    21834, 
    21835, 
    21836, 
    21837, 
    21838, 
    21839, 
    21840, 
    21841, 
    21842, 
    21843, 
    21844, 
    21845, 
    21846, 
    22984, 
    22980, 
    23976, 
    22974, 
    22987, 
    22986, 
    22985, 
    22983, 
    22982, 
    22981, 
    23977, 
    22978, 
    22977, 
    23978, 
    22976, 
    22975, 
    15386, 
    15387, 
    15389, 
    15393, 
    15396, 
    15397, 
    15400, 
    15401, 
    15402, 
    15403, 
    15406, 
    15407, 
    23306, 
    23316, 
    23308, 
    23307, 
    23317, 
    23310, 
    23311, 
    23312, 
    23313, 
    23314, 
    23315, 
    23309, 
    23318, 
    23319, 
    23320, 
    23321
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00559

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		251	Using index condition; Using filesort
1	SIMPLE	cscart_images	eq_ref	PRIMARY	PRIMARY	3	mahm3t_cs443.cscart_images_links.image_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	image_path	image_x	image_y	images_image_id
26275	15386	variant_image	21850	V	aps_651.png	101	97	21850
26276	15387	variant_image	21851	V	aps_652.png	116	112	21851
26278	15389	variant_image	21853	V	aps_654.png	116	112	21853
26282	15393	variant_image	21857	V	aps_658.png	137	132	21857
26285	15396	variant_image	21860	V	aps_661.png	118	114	21860
26286	15397	variant_image	21861	V	aps_662.png	101	97	21861
26289	15400	variant_image	21864	V	aps_665.png	116	112	21864
26290	15401	variant_image	21865	V	aps_666.png	139	135	21865
26291	15402	variant_image	21866	V	aps_667.png	189	183	21866
26292	15403	variant_image	21867	V	aps_668.png	141	136	21867
26295	15406	variant_image	21870	V	aps_671.png	155	151	21870
26296	15407	variant_image	21871	V	aps_672.png	134	130	21871
27133	15152	variant_image	22708	V	arz_102.png	126	126	22708
27134	15151	variant_image	22709	V	arz_101.png	152	151	22709
30399	21886	variant_image	25976	V	odv_rollo_alu.jpg	200	200	25976
30400	21887	variant_image	25977	V	odv_rollo_white.jpg	200	200	25977
30982	23306	variant_image	26560	V	odv_fhl_1016_ico.jpg	166	166	26560
30983	23316	variant_image	26561	V	odv_fhl_1256_ico.jpg	166	166	26561
30984	23308	variant_image	26562	V	odv_fhl_1259_ico.jpg	166	166	26562
30985	23307	variant_image	26563	V	odv_fhl_1274_ico.jpg	166	166	26563
30986	23317	variant_image	26564	V	odv_fhl_1275_ico.jpg	166	166	26564
30987	23310	variant_image	26565	V	odv_fhl_1276_ico.jpg	166	166	26565
30988	23311	variant_image	26566	V	odv_fhl_1277_ico.jpg	166	166	26566
30989	23312	variant_image	26567	V	odv_fhl_1278_ico.jpg	166	166	26567
30990	23313	variant_image	26568	V	odv_fhl_1279_ico.jpg	166	166	26568
30991	23314	variant_image	26569	V	odv_fhl_1280_ico.jpg	166	166	26569
30992	23315	variant_image	26570	V	odv_fhl_1281_ico.jpg	166	166	26570
30993	23309	variant_image	26571	V	odv_fhl_1282_ico.jpg	166	166	26571
30994	23318	variant_image	26572	V	odv_fhl_1283_ico.jpg	166	166	26572
30995	23319	variant_image	26573	V	odv_fhl_1284_ico.jpg	166	166	26573
30996	23320	variant_image	26574	V	odv_fhl_1285_ico.jpg	166	166	26574
30997	23321	variant_image	26575	V	odv_fhl_1286_ico.jpg	166	166	26575