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, 
    24304, 
    24305, 
    15775, 
    15776, 
    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, 
    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, 
    15152, 
    15151, 
    12642, 
    24136, 
    23691, 
    14038, 
    14039, 
    15309, 
    14040, 
    14041, 
    14215, 
    14042, 
    14043, 
    14044, 
    14045, 
    14046, 
    14047, 
    15373, 
    14048, 
    14049, 
    14050, 
    15365, 
    15366, 
    15363, 
    15364, 
    15362, 
    15367, 
    15368, 
    15431, 
    15432, 
    15433, 
    15435, 
    15748, 
    15749, 
    17701, 
    17702, 
    18188, 
    17703, 
    17704, 
    17705, 
    17706, 
    17707, 
    17708, 
    17709, 
    17710, 
    17711, 
    17712, 
    17713, 
    17714, 
    19712, 
    19713, 
    19726, 
    19714, 
    19715, 
    19725, 
    19716, 
    19717, 
    19718, 
    19724, 
    19719, 
    19720, 
    19721, 
    19722, 
    19723, 
    21889, 
    21888, 
    22389, 
    22390, 
    22391, 
    22392, 
    22393, 
    22394, 
    22395, 
    22396, 
    22397, 
    22429, 
    22430, 
    22431, 
    22432, 
    22433, 
    22434, 
    22435, 
    22451, 
    22452, 
    22474, 
    22475, 
    22482, 
    22483, 
    22485, 
    22486, 
    22488, 
    22489, 
    22490, 
    22491, 
    22492, 
    22493, 
    22495, 
    22496, 
    22497, 
    22739, 
    22740, 
    23687, 
    23704, 
    23705, 
    23706, 
    23709, 
    23707, 
    23708, 
    23904, 
    23905, 
    23906, 
    23907, 
    23908, 
    23909, 
    23910, 
    23911, 
    23912, 
    23913, 
    23914, 
    23915, 
    23916, 
    23917, 
    23918, 
    24286, 
    24285, 
    24284, 
    24283, 
    24276, 
    24275, 
    24277, 
    24282, 
    24281, 
    24280, 
    24279, 
    24278, 
    24274, 
    24288, 
    24287, 
    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, 
    23603, 
    14710, 
    14711, 
    15924, 
    14712, 
    14713, 
    14714, 
    14715, 
    14716, 
    14718, 
    22801, 
    22802, 
    22803, 
    22804, 
    22805, 
    22806, 
    15153, 
    15154, 
    15156, 
    15718, 
    15719, 
    15720, 
    15721, 
    15722, 
    15723, 
    15724, 
    15725, 
    15726, 
    15727, 
    15728, 
    15729, 
    15730, 
    15731, 
    15732, 
    15733, 
    15734, 
    15735, 
    15736, 
    15737, 
    15738, 
    17657, 
    17658, 
    17659, 
    17660, 
    17661, 
    17662, 
    17663, 
    17664, 
    17665, 
    17666, 
    17667, 
    17668, 
    17669, 
    17670, 
    17671, 
    17672, 
    17673, 
    17674, 
    17675, 
    17676, 
    17677, 
    17678, 
    19233, 
    19234, 
    19236, 
    19237, 
    19238, 
    19239, 
    19240, 
    19241, 
    19242, 
    19244, 
    19245, 
    19246, 
    24306, 
    19249, 
    19250, 
    19251, 
    19252, 
    23618, 
    19255, 
    19258, 
    19261, 
    19266, 
    19271, 
    19274, 
    19277, 
    19280, 
    19283, 
    19288, 
    19293, 
    19296, 
    19299, 
    19302, 
    19305, 
    19310, 
    19315, 
    19318, 
    21252, 
    23816, 
    21256, 
    21257, 
    21258, 
    21259, 
    21260, 
    21261, 
    21265, 
    21268, 
    21318, 
    21322, 
    21323, 
    21324, 
    21325, 
    21326, 
    21327, 
    23818, 
    21406, 
    21407, 
    21409, 
    21410, 
    21411, 
    21412, 
    21413, 
    21414, 
    21415, 
    21418, 
    21419, 
    21421, 
    21422, 
    21473, 
    21474, 
    21476, 
    21477, 
    21478, 
    21479, 
    21480, 
    21481, 
    21482, 
    21485, 
    21486, 
    21488, 
    21489, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    19636, 
    19638, 
    19639, 
    19640, 
    19641, 
    19642, 
    19637, 
    21388, 
    21390, 
    21391, 
    21392, 
    21393, 
    21397, 
    16108, 
    16109, 
    16110, 
    16111, 
    15792, 
    15793, 
    15794, 
    15795, 
    15796, 
    15797, 
    15798, 
    15799, 
    15800, 
    15801, 
    15802, 
    15803, 
    15804, 
    15805, 
    15806, 
    15807, 
    15104, 
    15105, 
    15553, 
    15106, 
    15107, 
    15554, 
    15108, 
    15109, 
    15110, 
    15111, 
    15112, 
    15113, 
    15114, 
    15115, 
    22118, 
    22119, 
    22120, 
    22121, 
    22122, 
    22123, 
    22124, 
    22125, 
    22126, 
    22506, 
    22127, 
    22128, 
    22129, 
    22321, 
    22320, 
    22319, 
    22318, 
    22317, 
    22316, 
    22315, 
    22314, 
    22322, 
    22323, 
    22324, 
    22325, 
    22326, 
    22327, 
    22328, 
    22329, 
    22398, 
    22399, 
    22400, 
    22401, 
    22402, 
    22403, 
    22404, 
    22405, 
    22406, 
    22407, 
    22408, 
    22409, 
    22410, 
    22411, 
    22412, 
    22413, 
    22414, 
    22415, 
    22416, 
    22417, 
    22418, 
    22419, 
    22420, 
    22421, 
    22422, 
    22423, 
    22424, 
    22425, 
    22426, 
    22427, 
    22459, 
    22460, 
    22462, 
    22463, 
    22465, 
    22466, 
    22467, 
    22469, 
    22470, 
    22471, 
    22472, 
    22473, 
    23587, 
    23588, 
    23589, 
    23590, 
    23591, 
    23688, 
    23592, 
    23593, 
    23594, 
    23595, 
    23596, 
    23597, 
    23598, 
    23599, 
    23673, 
    23674, 
    23675, 
    23676, 
    23677, 
    23678, 
    23679, 
    23680, 
    23681, 
    23682, 
    23683, 
    23684, 
    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, 
    22442, 
    22443, 
    22444, 
    23290, 
    23291, 
    23302, 
    23300, 
    23293, 
    23292, 
    23294, 
    23295, 
    23296, 
    23297, 
    23298, 
    23299, 
    23301, 
    23303, 
    23304, 
    23305, 
    22330, 
    22331, 
    22334, 
    22344, 
    22354, 
    22332, 
    22333, 
    22335, 
    22338, 
    22339, 
    22340, 
    22343, 
    22345, 
    22349, 
    22498, 
    22499, 
    22501, 
    22502, 
    24195, 
    22507, 
    22508, 
    22510, 
    22511, 
    24197, 
    22731, 
    22732, 
    22734, 
    22735, 
    24196
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.01494

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		712	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
26151	15153	variant_image	21726	V
26152	15154	variant_image	21727	V
26157	15156	variant_image	21732	V
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
26311	15431	variant_image	21886	V
26313	15433	variant_image	21888	V
26315	15435	variant_image	21890	V
27133	15152	variant_image	22708	V
27134	15151	variant_image	22709	V
27592	15775	variant_image	23167	V
27593	15776	variant_image	23168	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
30529	21888	variant_image	26106	V
30530	21889	variant_image	26107	V
30735	22330	variant_image	26313	V
30736	22331	variant_image	26314	V
30737	22332	variant_image	26315	V
30738	22333	variant_image	26316	V
30739	22334	variant_image	26317	V
30740	22335	variant_image	26318	V
30743	22338	variant_image	26321	V
30744	22339	variant_image	26322	V
30745	22340	variant_image	26323	V
30748	22343	variant_image	26326	V
30749	22344	variant_image	26327	V
30750	22345	variant_image	26328	V
30754	22349	variant_image	26332	V
30759	22354	variant_image	26337	V
30789	22396	variant_image	26367	V
30790	22397	variant_image	26368	V
30796	22498	variant_image	26374	V
30797	22499	variant_image	26375	V
30799	22501	variant_image	26377	V
30800	22502	variant_image	26378	V
30804	22507	variant_image	26382	V
30805	22508	variant_image	26383	V
30807	22510	variant_image	26385	V
30808	22511	variant_image	26386	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
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
31880	15432	variant_image	27458	V
31900	23704	variant_image	27478	V
31901	23705	variant_image	27479	V
31902	23706	variant_image	27480	V
31903	23707	variant_image	27481	V
31904	23708	variant_image	27482	V
31929	23709	variant_image	27507	V
32481	24195	variant_image	28059	V
32485	24197	variant_image	28063	V
32488	24196	variant_image	28066	V