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 = 'de' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    9963, 381, 429, 9913, 9912, 10139, 9916, 
    9911, 10138, 10217, 10142, 10141
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00127

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 12 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
1928 381 product 0 1873 M 0 velux-velta.jpg 1500 1177 1873
25373 9911 product 0 20960 M 0 fakro_wli.png Standard-Ausstiegsfenster "Fakro WLI mit universellem Eindeckrahmen 505 449 20960
25376 9912 product 0 20963 M 0 fakro_wg.png Standard-Ausstiegsfenster "Fakro WGT" mit ESG und universellem Eindeckrahmen 481 501 20963
25379 9913 product 0 20966 M 0 fakro_wg_6dcq-rc.png Standard-Ausstiegsfenster "FAKRO WGI" mit Verbundscheibe 481 501 20966
25383 9916 product 0 20970 M 0 fakro_ws.png Standard-Ausstiegsfenster "Fakro WS" mit dem Eindeckrahmen 460 349 20970
25561 9963 product 0 21136 M 0 loft02.jpg Kunststoff Ausstiegsfenster SkyLight LOFT 700 700 21136
27252 10138 product 0 22827 M 0 odv_gxu_000_khyr-77.jpg 800 800 22827
27257 10139 product 0 22832 M 0 vlx_gxl_00_679y-ir.jpg 1280 960 22832
27263 10141 product 0 22838 M 0 vlx_gxl_00_679y-ir_fn3h-9j_v56n-9a.jpg 1280 960 22838
27266 10142 product 0 22841 M 0 odv_gxu_000.jpg 800 800 22841
27786 10217 product 0 23361 M 0 odv_gxu_000.jpg 800 800 23361
32491 429 product 0 28069 M 0 Skyfens-Supro-Termo-LOFT-02__v1_.png 750 750 28069