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 = 'de' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    7313, 7304, 7315, 7297, 7303, 7309, 7307, 
    7306, 7298, 7305, 7310, 7299, 7300, 
    7311, 7302, 7314, 7317, 7301, 7312, 
    7308, 7316, 4033, 22146, 4035, 4037, 
    4038, 22147, 7077, 7078, 7079, 7081, 
    7082, 7083, 7281, 7282, 7283, 7284, 
    7285, 7286, 7287, 7288, 18133, 18134, 
    18169, 18171, 18172, 18173, 18174, 
    18176, 18183
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00191

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 51 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
13202 7281 variant_image 8828 0 V 0 potos_pa39.jpg 800 450 8828
13203 7282 variant_image 8829 0 V 0 potos_pa39p.jpg 800 450 8829
13204 7283 variant_image 8830 0 V 0 potos_pa45.jpg 800 450 8830
13205 7284 variant_image 8831 0 V 0 potos_pa45p.jpg 800 450 8831
13206 7285 variant_image 8832 0 V 0 potos_pa52.jpg 800 450 8832
13207 7286 variant_image 8833 0 V 0 potos_pa52p.jpg 800 450 8833
13208 7287 variant_image 8834 0 V 0 potos_pvc37p.jpg 800 450 8834
13209 7288 variant_image 8835 0 V 0 potos_pvc52p.jpg 800 450 8835
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