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 = 'fr' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    21886, 
    21887, 
    22807, 
    22808, 
    22809, 
    16015, 
    16003, 
    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, 
    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, 
    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, 
    22062, 
    22063, 
    22064, 
    22065, 
    22066, 
    22067, 
    22068, 
    22069, 
    22071, 
    22070, 
    22072, 
    22073, 
    22074, 
    22075, 
    22076, 
    22077, 
    22078, 
    22079, 
    22080, 
    22081, 
    22082, 
    22083, 
    22084, 
    22085, 
    22086, 
    22087, 
    22088, 
    22089, 
    22090, 
    22091, 
    22092, 
    22093, 
    22094, 
    22095, 
    22096, 
    22097, 
    22098, 
    22099, 
    22100, 
    22101, 
    22102, 
    22103, 
    22104, 
    22105, 
    22106, 
    22107, 
    22108, 
    22109, 
    22110, 
    22111, 
    22112, 
    22113, 
    22114, 
    22115, 
    22116, 
    22117, 
    22741, 
    22742, 
    22743, 
    22744, 
    22745, 
    22746, 
    22747, 
    22748, 
    22749, 
    22750, 
    22751, 
    22752, 
    22753, 
    22754, 
    22755, 
    22756, 
    22757, 
    22758, 
    22759, 
    22760, 
    22761, 
    24307, 
    24308, 
    24309, 
    24310, 
    24311, 
    24312, 
    24313, 
    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, 
    21894, 
    21895, 
    22739, 
    22740, 
    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, 
    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, 
    14710, 
    14711, 
    15924, 
    14712, 
    14713, 
    14714, 
    14715, 
    14716, 
    14718, 
    22801, 
    22802, 
    22803, 
    22804, 
    22805, 
    22806, 
    17657, 
    17658, 
    17659, 
    17660, 
    17661, 
    17662, 
    17663, 
    17664, 
    17665, 
    17666, 
    17667, 
    17668, 
    17669, 
    17670, 
    17671, 
    17672, 
    17673, 
    17674, 
    17675, 
    17676, 
    17677, 
    17678, 
    17679, 
    17680, 
    17681, 
    17682, 
    17683, 
    17684, 
    17685, 
    17686, 
    17687, 
    17688, 
    17689, 
    17690, 
    17691, 
    17692, 
    17693, 
    17694, 
    17695, 
    17696, 
    17697, 
    17698, 
    17699, 
    17700, 
    19233, 
    19234, 
    19236, 
    19237, 
    19238, 
    19239, 
    19240, 
    19241, 
    19242, 
    19244, 
    19245, 
    19246, 
    24306, 
    19249, 
    19250, 
    19251, 
    19252, 
    23618, 
    21870, 
    21871, 
    21872, 
    21873, 
    21874, 
    21875, 
    21876, 
    21877, 
    21878, 
    21879, 
    21880, 
    21881, 
    21882, 
    21883, 
    21884, 
    21885, 
    13652, 
    13654, 
    13657, 
    23306, 
    23316, 
    23308, 
    23307, 
    23317, 
    23310, 
    23311, 
    23312, 
    23313, 
    23314, 
    23315, 
    23309, 
    23318, 
    23319, 
    23320, 
    23321, 
    13595, 
    13596, 
    13602, 
    21897, 
    21898, 
    21900, 
    21901, 
    21896, 
    21902, 
    21904, 
    21903, 
    21905, 
    21906, 
    21907, 
    21908, 
    21910, 
    21911, 
    21909, 
    21899, 
    23290, 
    23291, 
    23302, 
    23300, 
    23293, 
    23292, 
    23294, 
    23295, 
    23296, 
    23297, 
    23298, 
    23299, 
    23301, 
    23303, 
    23304, 
    23305, 
    22731, 
    22732, 
    22734, 
    22735, 
    24196, 
    13704, 
    13707
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.01224

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		597	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
15165	13595	variant_image	10752	V
15166	13596	variant_image	10753	V
15172	13602	variant_image	10759	V
24314	13704	variant_image	19901	V
24317	13707	variant_image	19904	V
27932	16003	variant_image	23507	V
27944	16015	variant_image	23519	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
30868	22731	variant_image	26446	V
30869	22732	variant_image	26447	V
30871	22734	variant_image	26449	V
30872	22735	variant_image	26450	V
30982	23306	variant_image	26560	V
30983	23316	variant_image	26561	V
30984	23308	variant_image	26562	V
30985	23307	variant_image	26563	V
30986	23317	variant_image	26564	V
30987	23310	variant_image	26565	V
30988	23311	variant_image	26566	V
30989	23312	variant_image	26567	V
30990	23313	variant_image	26568	V
30991	23314	variant_image	26569	V
30992	23315	variant_image	26570	V
30993	23309	variant_image	26571	V
30994	23318	variant_image	26572	V
30995	23319	variant_image	26573	V
30996	23320	variant_image	26574	V
30997	23321	variant_image	26575	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
32488	24196	variant_image	28066	V