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 (
    8884, 10213, 10078, 8863, 10174, 395, 
    8873, 10163, 8894, 10212, 8885, 8893
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00250

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 31 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
12447 8863 product 0 8352 A 0 Okno-velux-GLL.jpg 2500 1875 8352
12485 8863 product 0 8391 A 0 Velux-GLL-dolne-otwieranie-scaled.jpg 1706 2560 8391
12487 8863 product 0 8393 A 0 velux-gllokno-1064b.jpg 1280 960 8393
12488 8863 product 0 8394 A 0 otwieranie-dolne-okno-dachowe-velux.jpg 460 351 8394
12489 8863 product 0 8395 A 0 drewniane-okno-dachowe-GLL-B.jpg 2500 1875 8395
12518 8884 product 0 8429 A 0 VELUX_GGU_003140442835353b5e041e38b8.jpg 1024 768 8429
12519 8884 product 0 8430 A 0 VELUX_GGU_005140442835353b5e041eb1f8.jpg 1024 768 8430
12520 8884 product 0 8431 A 0 VELUX_GGU_002140442835353b5e041f2c04.jpg 1024 768 8431
12521 8884 product 0 8432 A 0 VELUX_GGU_004140442835453b5e04206331.jpg 1024 768 8432
12522 8884 product 0 8433 A 0 VELUX_GGU_006140442835453b5e0420dc8e.jpg 1024 768 8433
12523 8885 product 0 8435 A 0 VELUX_GGU_003140442844553b5e09d3af68.jpg 1024 768 8435
12524 8885 product 0 8436 A 0 VELUX_GGU_005140442844553b5e09d44114.jpg 1024 768 8436
12525 8885 product 0 8437 A 0 VELUX_GGU_002140442844553b5e09d4e1cc.jpg 1024 768 8437
12526 8885 product 0 8438 A 0 VELUX_GGU_004140442844553b5e09d59c45.jpg 1024 768 8438
12527 8885 product 0 8439 A 0 VELUX_GGU_006140442844553b5e09d6374f.jpg 1024 768 8439
12563 8873 product 0 8481 A 0 VELUX_GGL_005140448468653b6bc4ef398e.jpg 1024 768 8481
12618 8893 product 0 8545 A 0 VELUX_GPU_005140448598953b6c16574b1c.jpg 1024 768 8545
12619 8893 product 0 8546 A 0 VELUX_GPU_002140448598953b6c1657d072.jpg 768 1024 8546
12620 8893 product 0 8547 A 0 VELUX_GPU_006140448598953b6c1658576f.jpg 1024 682 8547
12621 8893 product 0 8548 A 0 VELUX_GPU_003140448598953b6c1658e024.jpg 1024 768 8548
12622 8893 product 0 8549 A 0 VELUX_GPU_001140448598953b6c16596a24.jpg 1024 768 8549
12623 8894 product 0 8551 A 0 VELUX_GPU_005140448603753b6c1958015e.jpg 1024 768 8551
27401 10163 product 0 22976 A 0 u6.jpg Double-chamber U6 glazing unit 163 162 22976
27402 10163 product 0 22977 A 0 fakro_ftt_4_seals.png Quadruple sealing system 230 229 22977
27522 10174 product 0 23097 A 0 118584-01-L_xtq8-nq.jpg 1024 768 23097
27525 10174 product 0 23100 A 0 1_bcvf-87.png 1347 909 23100
27744 10212 product 0 23319 A 0 VELUX_GGL_005140448468653b6bc4ef398e_i424-34.jpg 1024 768 23319
27745 10212 product 0 23320 A 0 VELUX_GGL_007140448468753b6bc4f09a3a_x27e-07.jpg 1024 844 23320
27746 10212 product 0 23321 A 0 VELUX_GGL_003140448468753b6bc4f14e2d_xg2t-63.jpg 1024 728 23321
27747 10212 product 0 23322 A 0 VELUX_GGL_002140448468753b6bc4f1fd3c_g6r4-gf.jpg 1024 768 23322
27748 10212 product 0 23323 A 0 VELUX_GGL140448468753b6bc4f2ac9f_om6i-w9.jpg 1024 768 23323
27749 10212 product 0 23324 A 0 VELUX_GGL_004140448468753b6bc4f35286_9edc-ih.jpg 1024 768 23324
27750 10212 product 0 23325 A 0 VELUX_GGL_006140448468753b6bc4f3f921_hfjo-tk.jpg 1024 768 23325
27752 10213 product 0 23327 A 0 VELUX_GGU_003140442835353b5e041e38b8_16t2-hj.jpg 1024 768 23327
27753 10213 product 0 23328 A 0 VELUX_GGU_005140442835353b5e041eb1f8_1ge6-rh.jpg 1024 768 23328
27754 10213 product 0 23329 A 0 VELUX_GGU_002140442835353b5e041f2c04_991s-wu.jpg 1024 768 23329
27755 10213 product 0 23330 A 0 VELUX_GGU_004140442835453b5e04206331_27pv-wt.jpg 1024 768 23330
27756 10213 product 0 23331 A 0 VELUX_GGU_006140442835453b5e0420dc8e_r1nl-xx.jpg 1024 768 23331
27924 8873 product 0 23499 A 0 VELUX_GGL_004140448468753b6bc4f35286_ym15-q2.jpg 1024 768 23499
27925 8873 product 0 23500 A 0 VELUX_GGL_003140448468753b6bc4f14e2d_0dix-w0.jpg 1024 728 23500
27926 8873 product 0 23501 A 0 VELUX_GGL_002140448468753b6bc4f1fd3c_tod5-zq.jpg 1024 768 23501
28085 10078 product 0 23660 A 0 integra_kli_311_001_o6mo-g3_0rj2-q9.png 220 220 23660
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
29560 10163 product 0 25137 A 0 klamka_biala_8okk-g7.jpg 410 223 25137
31350 8863 product 0 26928 A 0 dachowe-okno-GLL-velux.jpg 2500 1875 26928
31351 8863 product 0 26929 A 0 nawiewnik-w-oknie-Velux-z-dolnym-otwieraniem-scaled.jpg 2560 1920 26929
31352 8863 product 0 26930 A 0 zdjecie-okno-1064b-velux-gll.jpg 1280 960 26930
31353 8863 product 0 26931 A 0 okno-velux-GLL-z-dolnym-otwieraniem.jpg 2500 1666 26931
31354 8863 product 0 26932 A 0 dodatki-okno-1064b-velux-gll.jpg 1280 960 26932
3098 395 product 0 2964 A 1 fakro_ftt_4_seals.png Quadruple sealing system 230 229 2964
12564 8873 product 0 8482 A 1 VELUX_GGL_007140448468753b6bc4f09a3a.jpg 1024 844 8482
12625 8894 product 0 8553 A 1 VELUX_GPU_006140448603753b6c19596221.jpg 1024 682 8553
26112 10078 product 0 21687 A 1 118181-01-XXL_pl2h-no.jpg 1280 960 21687
28084 10174 product 0 23659 A 1 integra_kli_311_001_o6mo-g3_a0hy-ft.png 220 220 23659
12626 8894 product 0 8554 A 2 VELUX_GPU_003140448603753b6c1959fc69.jpg 1024 768 8554
26115 10078 product 0 21690 A 2 115230-01-XXL.jpg 1280 960 21690
27519 10174 product 0 23094 A 2 118181-01-XXL_pl2h-no.jpg 1280 960 23094
12627 8894 product 0 8555 A 3 VELUX_GPU_001140448603753b6c195a9b25.jpg 1024 768 8555
26100 10078 product 0 21675 A 3 1.png 1347 909 21675
27510 10174 product 0 23085 A 3 115230-01-XXL.jpg 1280 960 23085
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
12567 8873 product 0 8485 A 4 VELUX_GGL140448468753b6bc4f2ac9f.jpg 1024 768 8485
12624 8894 product 0 8552 A 4 VELUX_GPU_002140448603753b6c1958b49b.jpg 768 1024 8552
26101 10078 product 0 21676 A 4 2.png 1242 888 21676
27523 10174 product 0 23098 A 4 120001-01-XXL_icpp-h1.jpg 1280 958 23098
12569 8873 product 0 8487 A 5 VELUX_GGL_006140448468753b6bc4f3f921.jpg 1024 768 8487
26102 10078 product 0 21677 A 5 3.png 1165 642 21677
27524 10174 product 0 23099 A 5 119096-01-XXL_x3rn-bf.jpg 1024 768 23099
26030 10078 product 0 21605 A 6 120000-01-XXL.jpg 1024 766 21605
26103 10078 product 0 21678 A 7 119108-01-XXL_1528-vc.jpg 1024 768 21678
27526 10174 product 0 23101 A 7 118936-01-XXL_o44g-sf.jpg 768 1024 23101
26104 10078 product 0 21679 A 8 119102-01-XXL_i98f-xy.jpg 1024 768 21679
27527 10174 product 0 23102 A 8 119151-01-XXL_o9if-1y.jpg 1024 682 23102
26105 10078 product 0 21680 A 9 119107-01-XXL_9mnb-h6.jpg 1024 768 21680
26123 10078 product 0 21698 A 10 121597-01-L.jpg 1280 960 21698