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 (
    21886, 
    21887, 
    13994, 
    14010, 
    14002, 
    14033, 
    14024, 
    14005, 
    14025, 
    14021, 
    14028, 
    14003, 
    14011, 
    14012, 
    13998, 
    14000, 
    14032, 
    14027, 
    14034, 
    21912, 
    21914, 
    21915, 
    21916, 
    21917, 
    21918, 
    21919, 
    21921, 
    21920, 
    21922, 
    21923, 
    21924, 
    21925, 
    21926, 
    21927, 
    21928, 
    21929, 
    21930, 
    21931, 
    21932, 
    21933, 
    21934, 
    21935, 
    21936, 
    21937, 
    21938, 
    21939, 
    21940, 
    21941, 
    21942, 
    21943, 
    21944, 
    21945, 
    21946, 
    21947, 
    21948, 
    21949, 
    21950, 
    21951, 
    21952, 
    21953, 
    21954, 
    21955, 
    21956, 
    21957, 
    21958, 
    21959, 
    21960, 
    21961, 
    21962, 
    21963, 
    21964, 
    21965, 
    21966, 
    21967, 
    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, 
    19808, 
    19809, 
    19822, 
    19810, 
    19811, 
    19821, 
    19812, 
    19813, 
    19814, 
    19815, 
    19816, 
    19817, 
    19823, 
    19818, 
    19819, 
    19820, 
    20768, 
    20769, 
    20770, 
    20771, 
    20772, 
    20773, 
    20774, 
    20775, 
    20776, 
    20777, 
    20779, 
    20780, 
    20781, 
    20782, 
    20783, 
    20784, 
    20966, 
    20967, 
    20968, 
    20969, 
    20970, 
    20971, 
    20972, 
    20973, 
    20974, 
    20975, 
    20978, 
    20979, 
    20980, 
    20981, 
    20982, 
    23837, 
    20984, 
    20985, 
    23838, 
    21495, 
    21496, 
    21498, 
    21499, 
    21500, 
    21501, 
    21502, 
    21503, 
    21504, 
    21507, 
    21508, 
    21510, 
    21511, 
    23827, 
    21234, 
    21235, 
    21236, 
    21237, 
    21238, 
    21239, 
    21243, 
    21246, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    19612, 
    19614, 
    19615, 
    19616, 
    19617, 
    19618, 
    19613, 
    23828, 
    21432, 
    23829, 
    21434, 
    21435, 
    21436, 
    21437, 
    21441, 
    20626, 
    20627, 
    20628, 
    20629, 
    20630, 
    20631, 
    20632, 
    20633, 
    20634, 
    20635, 
    20636, 
    20637, 
    20638, 
    20639, 
    20640, 
    20641, 
    20642, 
    20643, 
    20644, 
    20645, 
    20646, 
    20647, 
    21897, 
    21898, 
    21900, 
    21901, 
    21896, 
    21902, 
    21904, 
    21903, 
    21905, 
    21906, 
    21907, 
    21908, 
    21910, 
    21911, 
    21909, 
    21899
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00556

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		268	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
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