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, 
    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, 
    14038, 
    14039, 
    15309, 
    14040, 
    14041, 
    14215, 
    14042, 
    14043, 
    14044, 
    14045, 
    14046, 
    14047, 
    15373, 
    14048, 
    14049, 
    14050, 
    19534, 
    19535, 
    21894, 
    21895, 
    23900, 
    23901, 
    15153, 
    15154, 
    15156, 
    16187, 
    16188, 
    16189, 
    16190, 
    16191, 
    23887, 
    23888, 
    23886, 
    23885, 
    23891, 
    23890, 
    23889, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    21870, 
    21871, 
    21872, 
    21873, 
    21874, 
    21875, 
    21876, 
    21877, 
    21878, 
    21879, 
    21880, 
    21881, 
    21882, 
    21883, 
    21884, 
    21885, 
    21897, 
    21898, 
    21900, 
    21901, 
    21896, 
    21902, 
    21904, 
    21903, 
    21905, 
    21906, 
    21907, 
    21908, 
    21910, 
    21911, 
    21909, 
    21899, 
    14859, 
    14860, 
    14863, 
    14879, 
    14889, 
    14861, 
    14862, 
    14864, 
    14867, 
    14868, 
    14869, 
    14872, 
    14880, 
    14884
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00509

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 219 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
26151 15153 variant_image 21726 0 V 0 amz_089.png 89 89 21726
26152 15154 variant_image 21727 0 V 0 amz_090.png 97 97 21727
26157 15156 variant_image 21732 0 V 0 amz_092.png 98 98 21732
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
30531 21897 variant_image 26108 0 V 0 odv_rollo_1028_ico.jpg 166 228 26108
30532 21898 variant_image 26109 0 V 0 odv_rollo_1086_ico.jpg 166 228 26109
30533 21900 variant_image 26110 0 V 0 odv_rollo_4069_ico.jpg 166 228 26110
30534 21901 variant_image 26111 0 V 0 odv_rollo_4155_ico.jpg 166 228 26111
30535 21896 variant_image 26112 0 V 0 odv_rollo_4161_ico.jpg 166 228 26112
30536 21902 variant_image 26113 0 V 0 odv_rollo_4162_ico.jpg 166 228 26113
30537 21904 variant_image 26114 0 V 0 odv_rollo_4163_ico.jpg 166 228 26114
30538 21903 variant_image 26115 0 V 0 odv_rollo_4164_ico.jpg 166 228 26115
30539 21905 variant_image 26116 0 V 0 odv_rollo_4165_ico.jpg 166 228 26116
30540 21906 variant_image 26117 0 V 0 odv_rollo_4166_ico.jpg 166 228 26117
30541 21907 variant_image 26118 0 V 0 odv_rollo_4167_ico.jpg 166 228 26118
30542 21899 variant_image 26119 0 V 0 odv_rollo_9050_ico.jpg 166 228 26119
30543 21908 variant_image 26120 0 V 0 odv_rollo_4168_ico.jpg 166 228 26120
30544 21910 variant_image 26121 0 V 0 odv_rollo_4169_ico.jpg 166 228 26121
30545 21911 variant_image 26122 0 V 0 odv_rollo_4170_ico.jpg 166 228 26122
30546 21909 variant_image 26123 0 V 0 odv_rollo_4171_ico.jpg 166 228 26123
30681 14859 variant_image 26259 0 V 0 arf_1_051_5pf0-3p.jpg 800 600 26259
30682 14860 variant_image 26260 0 V 0 arf_1_052_auoz-09.jpg 800 600 26260
30683 14863 variant_image 26261 0 V 0 arf_1_055_jfxi-jn.jpg 800 600 26261
30684 14879 variant_image 26262 0 V 0 arf_1_255_rl2c-gf.jpg 800 600 26262
30685 14889 variant_image 26263 0 V 0 arf_1_265_zu14-jf.jpg 800 600 26263
30686 14861 variant_image 26264 0 V 0 arf_2_053_qihi-4o.jpg 800 600 26264
30687 14862 variant_image 26265 0 V 0 arf_2_054_i69z-1q.jpg 800 600 26265
30688 14864 variant_image 26266 0 V 0 arf_2_056_wvbi-ua.jpg 800 600 26266
30691 14867 variant_image 26269 0 V 0 arf_2_059_mys3-hw.jpg 800 600 26269
30692 14868 variant_image 26270 0 V 0 arf_2_226_x0p1-9d.jpg 800 600 26270
30693 14869 variant_image 26271 0 V 0 arf_2_227_n9ik-fc.jpg 800 600 26271
30696 14872 variant_image 26274 0 V 0 arf_2_233_w74j-oc.jpg 800 600 26274
30699 14880 variant_image 26277 0 V 0 arf_2_256_si7i-j7.jpg 800 600 26277
30703 14884 variant_image 26281 0 V 0 arf_2_260_b6lj-hn.jpg 800 600 26281