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 = 'se' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (395, 396, 10164) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00079

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 8 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
1080 395 product 0 1057 A 0 u6.jpg Double-chamber U6 glazing unit 163 162 1057
3095 396 product 0 2961 A 0 fakro_ftt_06.gif 200 200 2961
27406 10164 product 0 22981 A 0 fakro_ftt_06.gif 200 200 22981
27407 10164 product 0 22982 A 0 u8.jpg Triple-chamber U8 glazing unit 348 299 22982
27408 10164 product 0 22983 A 0 klamka_biala.jpg 4-glas 410 223 22983
27409 10164 product 0 22984 A 0 fakro_ftt_u8_10.png 1007 613 22984
27410 10164 product 0 22985 A 0 ftt-u8_03.jpg 415 233 22985
29452 396 product 0 25029 A 0 FTT_Thermo_07.jpg 2700 1800 25029
29453 396 product 0 25030 A 0 FTT_Thermo_11.jpg 2700 1802 25030
29457 395 product 0 25034 A 0 FTT_Thermo_01.jpg 1800 2700 25034
29458 395 product 0 25035 A 0 FTT_Thermo_02.jpg 1800 2700 25035
1081 396 product 0 1058 A 1 u8.jpg Triple-chamber U8 glazing unit 348 299 1058
3098 395 product 0 2964 A 1 fakro_ftt_4_seals.png Quadruple sealing system 230 229 2964
1082 396 product 0 1059 A 2 ftt-u8_04.jpg 4-glas 672 720 1059
29459 395 product 0 25036 A 3 FTT_Thermo_08.jpg 1800 2700 25036
29460 395 product 0 25037 A 3 FTT_Thermo_09.jpg 2700 1800 25037
29461 395 product 0 25038 A 3 FTT_Thermo_10.jpg 2700 1800 25038
29462 395 product 0 25039 A 3 FTT_Thermo_13.jpg 2700 1847 25039
25380 396 product 0 20967 A 4 fakro_ftt_u8_10.png 1007 613 20967
1083 396 product 0 1060 A 5 ftt-u8_03.jpg 415 233 1060
29454 396 product 0 25031 A 7 FTT_Thermo_12.jpg 2700 2068 25031