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.detailed_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 = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (8295, 1310, 1311) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00157

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 10 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.detailed_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
30930 8295 product 0 26508 A 0 Insektenschutz-Rollos_für_Dachfenster_.jpg 2400 3200 26508
31183 1311 product 0 26761 A 0 roto_zar_02.jpg 1728 972 26761
31184 1311 product 0 26762 A 0 roto_zar_03.jpg 1728 972 26762
31185 1311 product 0 26763 A 0 roto_zar_04.jpg 1728 972 26763
31186 1311 product 0 26764 A 0 roto_zar_05.jpg 1728 972 26764
31187 1311 product 0 26765 A 0 roto_zar_06.jpg 1728 972 26765
31197 1310 product 0 26775 A 0 blackout-roller-blinds-detail-02.jpg 1124 633 26775
31198 1310 product 0 26776 A 0 blackout-roller-blinds-detail-03.jpg 1124 633 26776
31199 1310 product 0 26777 A 0 blackout-roller-blinds-detail-04.jpg 1140 642 26777
32515 8295 product 0 28093 A 1 ZIA_dakea_close_02.png 542 721 28093
32519 8295 product 0 28097 A 2 ZIA_dakea_close_01_1y3i-sh.png 542 721 28097
32520 8295 product 0 28098 A 3 ZIA_NB_detail_01.png 542 721 28098
32513 8295 product 0 28091 A 4 ZIA_packshot_01.png 500 500 28091
30897 8295 product 0 26475 A 5 insektenschutz-rollos-unboxing.png 900 974 26475
30896 8295 product 0 26474 A 6 insektenschutz-rollos-montagehinweise.png 1000 1150 26474
30898 8295 product 0 26476 A 7 insect_screen_montage_tips.png 1571 896 26476
30899 8295 product 0 26477 A 8 insect_screen_installation_tips.png 1573 624 26477
32521 8295 product 0 28099 A 9 ZIA_dakea_bedroom_01.png 482 721 28099
30931 8295 product 0 26509 A 10 Moustiquaire_pour_fenêtre_de_toit_.jpg 2400 1600 26509