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 (
    8886, 8891, 10211, 8870, 8868, 10173, 
    8887, 8884, 10213, 10078, 8863, 10174
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00228

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 27 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
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
12543 8868 product 0 8458 A 0 VELUX_GGL_005140442896953b5e2a9c2194.jpg 1024 768 8458
12544 8868 product 0 8459 A 0 VELUX_GGL_003140442896953b5e2a9c9c14.jpg 1024 728 8459
12545 8868 product 0 8460 A 0 VELUX_GGL_002140442896953b5e2a9d1d73.jpg 1024 768 8460
12546 8868 product 0 8461 A 0 VELUX_GGL_003140442896953b5e2a9d8bf4.jpg 1024 728 8461
12547 8868 product 0 8462 A 0 VELUX_GGL_004140442896953b5e2a9e0370.jpg 1024 768 8462
12548 8868 product 0 8463 A 0 VELUX_GGL140442896953b5e2a9e99fc.jpg 1024 768 8463
12555 8868 product 0 8471 A 0 VELUX_GGL_006140442918453b5e3807b5c1.jpg 1024 768 8471
12608 8891 product 0 8533 A 0 VELUX_GPU_005140448588753b6c0ff0e2fb.jpg 1024 768 8533
12609 8891 product 0 8534 A 0 VELUX_GPU_006140448588753b6c0ff18c2e.jpg 1024 682 8534
12610 8891 product 0 8535 A 0 VELUX_GPU_003140448588753b6c0ff2337e.jpg 1024 768 8535
12611 8891 product 0 8536 A 0 VELUX_GPU_001140448588753b6c0ff2d8e7.jpg 1024 768 8536
12612 8891 product 0 8537 A 0 VELUX_GPU_002140448588753b6c0ff38908.jpg 768 1024 8537
12670 8887 product 0 8606 A 0 VELUX_GGU_Integra_03140520118353c1ab1f43c20.jpg 600 400 8606
12671 8887 product 0 8607 A 0 VELUX_GGU_001140520118353c1ab1f4fa80.jpg 932 768 8607
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
27529 10173 product 0 23104 A 0 okno-poliuretanowe-glu-velux-dolne-otwieranie.jpg 1280 853 23104
27530 10173 product 0 23105 A 0 Velux-GLU-0061-przekroj-e1618914908423.jpg 681 584 23105
27738 10211 product 0 23313 A 0 VELUX_GPU_005140448598953b6c16574b1c.jpg 1024 768 23313
27739 10211 product 0 23314 A 0 VELUX_GPU_002140448598953b6c1657d072.jpg 768 1024 23314
27740 10211 product 0 23315 A 0 VELUX_GPU_006140448598953b6c1658576f.jpg 1024 682 23315
27741 10211 product 0 23316 A 0 VELUX_GPU_003140448598953b6c1658e024.jpg 1024 768 23316
27742 10211 product 0 23317 A 0 VELUX_GPU_001140448598953b6c16596a24.jpg 1024 768 23317
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
28085 10078 product 0 23660 A 0 integra_kli_311_001_o6mo-g3_0rj2-q9.png 220 220 23660
30770 10173 product 0 26348 A 0 VELUX-GLU-okno-0064b-wnetrze_v2sn-dh.jpg 1280 960 26348
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
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
12647 8886 product 0 8579 A 2 VELUX_GGU_Integra_03140520009253c1a6dce8aad.jpg 600 400 8579
12659 8870 product 0 8593 A 2 velux_ggl_integra_03140520083053c1a9be09c9c.jpg 600 400 8593
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
12642 8886 product 0 8573 A 3 VELUX_GGU_001140519960353c1a4f398241.jpg 932 768 8573
12660 8870 product 0 8594 A 3 VELUX_GGL140520083053c1a9be12ed4.jpg 1024 768 8594
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
31374 10173 product 0 26952 A 3 zdjecie-okno-0064b-GLU-VELUX_avyb-lc.jpg 1280 960 26952
31375 10173 product 0 26953 A 3 GLU-0064b_0c3j-d2.jpg 1280 960 26953
31376 10173 product 0 26954 A 3 Nawiewnik-w-oknie-dachowym-Velux-z-dolnym-otwieraniem-scaled_dr5f-pz.jpg 2560 1920 26954
31377 10173 product 0 26955 A 3 otwieranie-okna-dolna-klamka-velux_cam7-ts.jpg 1280 905 26955
31378 10173 product 0 26956 A 3 Klamka-okna-GLU-scaled_jovb-c8.jpg 2560 1920 26956
12643 8886 product 0 8574 A 4 VELUX_GGU_003140519960353c1a4f3a15d4.jpg 1024 768 8574
12661 8870 product 0 8595 A 4 VELUX_GGL_007140520083053c1a9be1bf73.jpg 1024 844 8595
26101 10078 product 0 21676 A 4 2.png 1242 888 21676
26118 8886 product 0 21693 A 4 115230-01-XXL_lvyi-1z.jpg 1280 960 21693
27523 10174 product 0 23098 A 4 120001-01-XXL_icpp-h1.jpg 1280 958 23098
12657 8870 product 0 8591 A 5 velux_ggl_3073_04140520082953c1a9bdeaf67.jpg 550 367 8591
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
12662 8870 product 0 8596 A 6 VELUX_GGL_006140520083053c1a9be25dc7.jpg 1024 768 8596
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