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 = '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, 
    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, 
    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, 
    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, 
    23290, 
    23291, 
    23302, 
    23300, 
    23293, 
    23292, 
    23294, 
    23295, 
    23296, 
    23297, 
    23298, 
    23299, 
    23301, 
    23303, 
    23304, 
    23305, 
    22731, 
    22732, 
    22734, 
    22735, 
    24196
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00686

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 293 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 detailed_id type position emo_md5 image_path alt image_x image_y images_image_id
27932 16003 variant_image 23507 0 V 0 AUB-002.jpg 100 100 23507
27944 16015 variant_image 23519 0 V 0 AUB-014.jpg 100 100 23519
30373 21870 variant_image 25950 0 V 0 odv_rollo_0705_ico.jpg 166 228 25950
30374 21871 variant_image 25951 0 V 0 odv_rollo_1025_ico.jpg 166 228 25951
30375 21872 variant_image 25952 0 V 0 odv_rollo_1085_ico.jpg 166 228 25952
30376 21873 variant_image 25953 0 V 0 odv_rollo_1100_ico.jpg 166 228 25953
30377 21874 variant_image 25954 0 V 0 odv_rollo_3009_ico.jpg 166 228 25954
30378 21875 variant_image 25955 0 V 0 odv_rollo_4556_ico.jpg 166 228 25955
30379 21876 variant_image 25956 0 V 0 odv_rollo_4559_ico.jpg 166 228 25956
30380 21877 variant_image 25957 0 V 0 odv_rollo_4564_ico.jpg 166 228 25957
30381 21878 variant_image 25958 0 V 0 odv_rollo_4574_ico.jpg 166 228 25958
30382 21879 variant_image 25959 0 V 0 odv_rollo_4575_ico.jpg 166 228 25959
30383 21880 variant_image 25960 0 V 0 odv_rollo_4576_ico.jpg 166 228 25960
30384 21881 variant_image 25961 0 V 0 odv_rollo_4577_ico.jpg 166 228 25961
30385 21882 variant_image 25962 0 V 0 odv_rollo_4578_ico.jpg 166 228 25962
30386 21883 variant_image 25963 0 V 0 odv_rollo_4579_ico.jpg 166 228 25963
30387 21884 variant_image 25964 0 V 0 odv_rollo_4580_ico.jpg 166 228 25964
30388 21885 variant_image 25965 0 V 0 odv_rollo_4581_ico.jpg 166 228 25965
30399 21886 variant_image 25976 0 V 0 odv_rollo_alu.jpg 200 200 25976
30400 21887 variant_image 25977 0 V 0 odv_rollo_white.jpg 200 200 25977
30868 22731 variant_image 26446 0 V 0 atr_dua_4208_ico_9p55-2n.jpg 327 328 26446
30869 22732 variant_image 26447 0 V 0 atr_dua_4212_ico_h598-ik.jpg 335 335 26447
30871 22734 variant_image 26449 0 V 0 atr_dua_4217_ico_j6i0-v3.jpg 332 333 26449
30872 22735 variant_image 26450 0 V 0 atr_dua_4219_ico_dan4-gq.jpg 331 327 26450
30998 23290 variant_image 26576 0 V 0 odv_fhc_1045_ico.jpg 166 166 26576
30999 23291 variant_image 26577 0 V 0 odv_fhc_1047_ico.jpg 166 166 26577
31000 23302 variant_image 26578 0 V 0 odv_fhc_1049_ico.jpg 166 166 26578
31001 23300 variant_image 26579 0 V 0 odv_fhc_1155_ico.jpg 166 166 26579
31002 23293 variant_image 26580 0 V 0 odv_fhc_1156_ico.jpg 166 166 26580
31003 23292 variant_image 26581 0 V 0 odv_fhc_1163_ico.jpg 166 166 26581
31004 23294 variant_image 26582 0 V 0 odv_fhc_1164_ico.jpg 166 166 26582
31005 23295 variant_image 26583 0 V 0 odv_fhc_1165_ico.jpg 166 166 26583
31006 23296 variant_image 26584 0 V 0 odv_fhc_1166_ico.jpg 166 166 26584
31007 23297 variant_image 26585 0 V 0 odv_fhc_1167_ico.jpg 166 166 26585
31008 23298 variant_image 26586 0 V 0 odv_fhc_1168_ico.jpg 166 166 26586
31009 23299 variant_image 26587 0 V 0 odv_fhc_1169_ico.jpg 166 166 26587
31010 23301 variant_image 26588 0 V 0 odv_fhc_1170_ico.jpg 166 166 26588
31011 23303 variant_image 26589 0 V 0 odv_fhc_1171_ico.jpg 166 166 26589
31012 23304 variant_image 26590 0 V 0 odv_fhc_1172_ico.jpg 166 166 26590
31013 23305 variant_image 26591 0 V 0 odv_fhc_1173_ico.jpg 166 166 26591
32488 24196 variant_image 28066 0 V 0 atr_dua_4204_ico_6lba-42.jpg 332 333 28066