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 = '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.00576

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.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
26299	15374	variant_image	21874	V	apf_601.png	183	189	21874
26300	15375	variant_image	21875	V	apf_602.png	126	128	21875
26301	15376	variant_image	21876	V	apf_603.png	183	189	21876
26302	15377	variant_image	21877	V	apf_604.png	136	141	21877
26303	15378	variant_image	21878	V	apf_605.png	166	172	21878
26304	15379	variant_image	21879	V	apf_606.png	112	116	21879
26305	15380	variant_image	21880	V	apf_607.png	143	148	21880
26307	15382	variant_image	21882	V	apf_609.png	151	156	21882
26309	15384	variant_image	21884	V	apf_611.png	124	128	21884
26310	15385	variant_image	21885	V	apf_612.png	174	180	21885
27133	15152	variant_image	22708	V	arz_102.png	126	126	22708
27134	15151	variant_image	22709	V	arz_101.png	152	151	22709
30373	21870	variant_image	25950	V	odv_rollo_0705_ico.jpg	166	228	25950
30374	21871	variant_image	25951	V	odv_rollo_1025_ico.jpg	166	228	25951
30375	21872	variant_image	25952	V	odv_rollo_1085_ico.jpg	166	228	25952
30376	21873	variant_image	25953	V	odv_rollo_1100_ico.jpg	166	228	25953
30377	21874	variant_image	25954	V	odv_rollo_3009_ico.jpg	166	228	25954
30378	21875	variant_image	25955	V	odv_rollo_4556_ico.jpg	166	228	25955
30379	21876	variant_image	25956	V	odv_rollo_4559_ico.jpg	166	228	25956
30380	21877	variant_image	25957	V	odv_rollo_4564_ico.jpg	166	228	25957
30381	21878	variant_image	25958	V	odv_rollo_4574_ico.jpg	166	228	25958
30382	21879	variant_image	25959	V	odv_rollo_4575_ico.jpg	166	228	25959
30383	21880	variant_image	25960	V	odv_rollo_4576_ico.jpg	166	228	25960
30384	21881	variant_image	25961	V	odv_rollo_4577_ico.jpg	166	228	25961
30385	21882	variant_image	25962	V	odv_rollo_4578_ico.jpg	166	228	25962
30386	21883	variant_image	25963	V	odv_rollo_4579_ico.jpg	166	228	25963
30387	21884	variant_image	25964	V	odv_rollo_4580_ico.jpg	166	228	25964
30388	21885	variant_image	25965	V	odv_rollo_4581_ico.jpg	166	228	25965
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
30998	23290	variant_image	26576	V	odv_fhc_1045_ico.jpg	166	166	26576
30999	23291	variant_image	26577	V	odv_fhc_1047_ico.jpg	166	166	26577
31000	23302	variant_image	26578	V	odv_fhc_1049_ico.jpg	166	166	26578
31001	23300	variant_image	26579	V	odv_fhc_1155_ico.jpg	166	166	26579
31002	23293	variant_image	26580	V	odv_fhc_1156_ico.jpg	166	166	26580
31003	23292	variant_image	26581	V	odv_fhc_1163_ico.jpg	166	166	26581
31004	23294	variant_image	26582	V	odv_fhc_1164_ico.jpg	166	166	26582
31005	23295	variant_image	26583	V	odv_fhc_1165_ico.jpg	166	166	26583
31006	23296	variant_image	26584	V	odv_fhc_1166_ico.jpg	166	166	26584
31007	23297	variant_image	26585	V	odv_fhc_1167_ico.jpg	166	166	26585
31008	23298	variant_image	26586	V	odv_fhc_1168_ico.jpg	166	166	26586
31009	23299	variant_image	26587	V	odv_fhc_1169_ico.jpg	166	166	26587
31010	23301	variant_image	26588	V	odv_fhc_1170_ico.jpg	166	166	26588
31011	23303	variant_image	26589	V	odv_fhc_1171_ico.jpg	166	166	26589
31012	23304	variant_image	26590	V	odv_fhc_1172_ico.jpg	166	166	26590
31013	23305	variant_image	26591	V	odv_fhc_1173_ico.jpg	166	166	26591