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 (
    598, 8373, 1187, 597, 10103, 582, 579, 
    576, 10191, 1154, 9864, 10186
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00103

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 15 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
3555 1154 product 0 2996 A 0 kleber_21362166765513103edec531.jpg 900 630 2996
11140 8373 product 0 7955 A 0 kleber3.jpg 825 630 7955
11141 8373 product 0 7956 A 0 kleber_2.jpg 900 630 7956
11852 8373 product 0 8326 A 0 sol_kleber_ce_de.jpg 480 631 8326
11853 8373 product 0 8327 A 0 sol_kleber_kiwa_u_de.jpg 480 679 8327
12762 576 product 0 8675 A 0 Terplan_R_02.jpg 623 213 8675
12763 576 product 0 8676 A 0 Terplan_R_04.jpg 504 370 8676
12764 576 product 0 8677 A 0 Terplan_R_03.jpg 505 371 8677
12771 579 product 0 8684 A 0 atlas_inter_02.jpg 452 533 8684
12772 579 product 0 8685 A 0 atlas_inter_04.jpg 554 542 8685
12773 579 product 0 8686 A 0 atlas_inter_03.jpg 548 275 8686
15147 9864 product 0 10734 A 0 knauf_betokontakt_02.png 904 517 10734
15148 9864 product 0 10735 A 0 knauf_betokontakt_03.png 314 421 10735
15149 9864 product 0 10736 A 0 knauf_betokontakt_04.png 315 419 10736
27588 598 product 0 23163 A 0 knauf_mp_75_10.jpg 434 325 23163
27589 598 product 0 23164 A 0 knauf_mp_75_11.jpg 434 326 23164
27590 598 product 0 23165 A 0 knauf_mp_75_12.jpg 434 326 23165
27591 598 product 0 23166 A 0 knauf_mp_75_13.jpg 434 325 23166
30891 1187 product 0 26469 A 0 _path865.png Vorteile SILKA Kalksandstein 1233 648 26469
31636 1187 product 0 27214 A 0 silika-e-18.jpg 616 600 27214