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 (
    4033, 22146, 4035, 4037, 4038, 22147, 
    7077, 7078, 7079, 7081, 7082, 7083, 
    18133, 18134, 18169, 18171, 18172, 
    18173, 18174, 18176, 18183
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00114

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 22 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
1405 4033 variant_image 1350 0 V 0 vp70_biale.jpg 369 400 1350
1406 4035 variant_image 1351 0 V 0 vp70_zloty-dab.jpg 369 400 1351
1408 4037 variant_image 1353 0 V 0 vp70_orzech.jpg 369 400 1353
1497 4038 variant_image 1442 0 V 0 vp70_mahon.jpg 369 400 1442
11606 7077 variant_image 8099 0 V 0 7077_v90plus_bialy.jpg 369 447 8099
11607 7078 variant_image 8100 0 V 0 v82_winchester.jpg 280 339 8100
11608 7079 variant_image 8101 0 V 0 v82_zlotydab_.jpg 369 447 8101
11610 7081 variant_image 8103 0 V 0 v82_orzech.jpg 369 447 8103
11611 7082 variant_image 8104 0 V 0 v82_mahon.jpg 280 339 8104
11612 7083 variant_image 8105 0 V 0 v82_ciemnoszary.jpg 280 339 8105
28427 18169 variant_image 24002 0 V 0 ec_veka_bialy.jpg 286 450 24002
28428 18171 variant_image 24003 0 V 0 ec_veka_winchester.jpg 286 450 24003
28429 18172 variant_image 24004 0 V 0 ec_veka_zloty_dab.jpg 286 450 24004
28430 18173 variant_image 24005 0 V 0 ec_veka_orzech_wloski.jpg 286 450 24005
28431 18174 variant_image 24006 0 V 0 ec_veka_dab_bagienny.jpg 286 450 24006
28433 18176 variant_image 24008 0 V 0 ec_veka_antracyt_gladki.jpg 286 450 24008
28440 18183 variant_image 24015 0 V 0 ec_rehau_antracyt_metaliczny_szczotkowany.jpg 286 450 24015
30599 22146 variant_image 26176 0 V 0 v82_winchester.jpg 280 339 26176
30601 22147 variant_image 26178 0 V 0 v82_ciemnoszary.jpg 280 339 26178