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, 
    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, 
    19506, 
    19484, 
    19485, 
    19486, 
    19487, 
    19488, 
    19489, 
    19490, 
    19491, 
    19492, 
    19493, 
    19494, 
    19495, 
    19496, 
    19497, 
    19498, 
    19500, 
    19501, 
    19502, 
    19503, 
    19504, 
    19505, 
    15152, 
    15151, 
    14038, 
    14039, 
    15309, 
    14040, 
    14041, 
    14215, 
    14042, 
    14043, 
    14044, 
    14045, 
    14046, 
    14047, 
    15373, 
    14048, 
    14049, 
    14050, 
    15748, 
    15749, 
    19712, 
    19713, 
    19726, 
    19714, 
    19715, 
    19725, 
    19716, 
    19717, 
    19718, 
    19724, 
    19719, 
    19720, 
    19721, 
    19722, 
    19723, 
    23325, 
    23326, 
    23323, 
    23324, 
    23328, 
    23329, 
    23330, 
    23331, 
    23332, 
    23333, 
    23335, 
    23336, 
    23337, 
    23338, 
    23339, 
    23346, 
    23340, 
    23347, 
    23341, 
    23348, 
    23342, 
    23349, 
    23343, 
    23350, 
    23344, 
    23345, 
    23351, 
    23357, 
    23352, 
    23358, 
    23353, 
    23359, 
    23354, 
    23360, 
    23355, 
    23356, 
    23361, 
    23362, 
    23363, 
    23367, 
    23368, 
    23364, 
    23369, 
    23365, 
    23366, 
    23370, 
    23375, 
    23371, 
    23376, 
    23372, 
    23377, 
    23373, 
    23374, 
    19277, 
    19280, 
    19283, 
    19288, 
    19293, 
    19296, 
    19299, 
    19302, 
    19305, 
    19310, 
    19315, 
    19318, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    21388, 
    21390, 
    21391, 
    21392, 
    21393, 
    21397, 
    16108, 
    16109, 
    16110, 
    16111, 
    15374, 
    15375, 
    15376, 
    15377, 
    15378, 
    15379, 
    15380, 
    15382, 
    15384, 
    15385, 
    23619, 
    21870, 
    21871, 
    21872, 
    21873, 
    21874, 
    21875, 
    21876, 
    21877, 
    21878, 
    21879, 
    21880, 
    21881, 
    21882, 
    21883, 
    21884, 
    21885, 
    23290, 
    23291, 
    23302, 
    23300, 
    23293, 
    23292, 
    23294, 
    23295, 
    23296, 
    23297, 
    23298, 
    23299, 
    23301, 
    23303, 
    23304, 
    23305
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00537

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		264	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
26299	15374	variant_image	21874	V
26300	15375	variant_image	21875	V
26301	15376	variant_image	21876	V
26302	15377	variant_image	21877	V
26303	15378	variant_image	21878	V
26304	15379	variant_image	21879	V
26305	15380	variant_image	21880	V
26307	15382	variant_image	21882	V
26309	15384	variant_image	21884	V
26310	15385	variant_image	21885	V
27133	15152	variant_image	22708	V
27134	15151	variant_image	22709	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
30998	23290	variant_image	26576	V
30999	23291	variant_image	26577	V
31000	23302	variant_image	26578	V
31001	23300	variant_image	26579	V
31002	23293	variant_image	26580	V
31003	23292	variant_image	26581	V
31004	23294	variant_image	26582	V
31005	23295	variant_image	26583	V
31006	23296	variant_image	26584	V
31007	23297	variant_image	26585	V
31008	23298	variant_image	26586	V
31009	23299	variant_image	26587	V
31010	23301	variant_image	26588	V
31011	23303	variant_image	26589	V
31012	23304	variant_image	26590	V
31013	23305	variant_image	26591	V