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 = 'feature_variant' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    6243, 6288, 6289, 6300, 6278, 128, 130, 
    125, 5891, 129, 240, 6131, 5870, 126, 
    6124, 5771, 5890, 5893, 5773, 123, 212, 
    6223, 6221, 6222, 5936, 5937, 5933, 
    5935, 5892, 5938, 5932, 5894, 158
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00153

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 33 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
13323 5890 feature_variant 8910 0 V 0 stegu_logo.png 180 86 8910
13347 123 feature_variant 8934 0 V 0 atlas_logo.png 105 99 8934
13348 158 feature_variant 8935 0 V 0 barlinek_logo.png 474 106 8935
13349 128 feature_variant 8936 0 V 0 fakro_logo.png 436 115 8936
13350 240 feature_variant 8937 0 V 0 velux_logo.png 226 75 8937
13351 5870 feature_variant 8938 0 V 0 ytong_logo.png 176 75 8938
13352 5771 feature_variant 8939 0 V 0 creaton_logo.png 484 104 8939
13353 130 feature_variant 8940 0 V 0 optilight_logo.png 160 44 8940
13354 129 feature_variant 8941 0 V 0 arbonia_logo.jpg 1504 211 8941
13355 125 feature_variant 8942 0 V 0 rockwool_logo.gif 227 39 8942
13356 5773 feature_variant 8943 0 V 0 solbet_logo.png 433 116 8943
13357 212 feature_variant 8944 0 V 0 termoorganika_logo.PNG 218 40 8944
13358 126 feature_variant 8945 0 V 0 ursa_logo.png 145 80 8945
13359 5891 feature_variant 8946 0 V 0 knauf_logo.gif 180 115 8946
13360 5892 feature_variant 8947 0 V 0 siniat_logo.gif 305 115 8947
13361 5893 feature_variant 8948 0 V 0 kronospan_logo.png 224 61 8948
13444 5894 feature_variant 9031 0 V 0 pozbud_logo.png POZBUD 229 220 9031
25581 5937 feature_variant 21156 0 V 0 koelner_logo.png Koelner 200 98 21156
25582 5933 feature_variant 21157 0 V 0 mdm_logo.png mdm 136 23 21157
25583 5935 feature_variant 21158 0 V 0 portos_logo.png Portos 200 110 21158
25584 5938 feature_variant 21159 0 V 0 soudal_logo.png Soudal 342 147 21159
25585 5932 feature_variant 21160 0 V 0 vetrex_logo_de.png Vetrex 207 56 21160
25586 5936 feature_variant 21161 0 V 0 rawplug_logo.jpg 503 100 21161
28339 6131 feature_variant 23914 0 V 0 rlp_logo.jpg 923 288 23914
28340 6124 feature_variant 23915 0 V 0 roto_logo.jpg 640 400 23915
28346 6221 feature_variant 23921 0 V 0 logo_rehau.jpg 640 267 23921
28347 6222 feature_variant 23922 0 V 0 logo_schuco.jpg 800 215 23922
28348 6223 feature_variant 23923 0 V 0 logo_veka.png 700 175 23923