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 = 'A' 
  AND cscart_images_links.object_id IN (
    10163, 704, 8894, 10212, 8885, 8893, 
    9966, 523, 517, 8871, 10210, 9822
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00229

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 25 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
11637 704 product 0 8130 A 0 XDP-02_1_2.jpg Folienanschluss XDP von FAKRO - einfache Verbindung des Fensters mit dampfdurchlässiger Folie am Dach 1000 1000 8130
11638 704 product 0 8131 A 0 xdp_02.jpg FAKRO Folienanschluss XDP - Schutz der verwendeten Wärmedämmung 800 789 8131
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
12549 8871 product 0 8465 A 0 VELUX_GGL_005140442913453b5e34e924bf.jpg 1024 768 8465
12550 8871 product 0 8466 A 0 VELUX_GGL_003140442913453b5e34e9adc3.jpg 1024 728 8466
12551 8871 product 0 8467 A 0 VELUX_GGL_002140442913453b5e34ea4472.jpg 1024 768 8467
12552 8871 product 0 8468 A 0 VELUX_GGL_004140442913453b5e34eae105.jpg 1024 768 8468
12553 8871 product 0 8469 A 0 VELUX_GGL140442913453b5e34eb7a1e.jpg 1024 768 8469
12554 8871 product 0 8470 A 0 VELUX_GGL_006140442913453b5e34ec2228.jpg 1024 768 8470
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
27730 10210 product 0 23305 A 0 116278-01-L140448537553b6beffcfed8_8gxp-dz.jpg 1280 960 23305
27731 10210 product 0 23306 A 0 115326-01-XXL140448537553b6beffe3bde_qv0d-bs.jpg 2500 1875 23306
27732 10210 product 0 23307 A 0 115405-01-XXL140448537553b6beffed06b_66jz-i0.jpg 2500 1875 23307
27733 10210 product 0 23308 A 0 115492-01-XXL140448537653b6bf000250c_hxye-d8.jpg 2500 1875 23308
27734 10210 product 0 23309 A 0 119612-01-XXL140448537653b6bf000c9c4_f1bu-hp.jpg 2500 1875 23309
27735 10210 product 0 23310 A 0 119580-01-XXL140448537653b6bf0015627_gp5e-fj.jpg 2500 1896 23310
27736 10210 product 0 23311 A 0 112136-01-XXL140448537553b6beffd9cd9_d6ed-kq.jpg 2500 1875 23311
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
29560 10163 product 0 25137 A 0 klamka_biala_8okk-g7.jpg 410 223 25137
31297 517 product 0 26875 A 0 Okno-dachowe-RoofLITE-Slim-Vent-drewniane-wentylowane-78x118_1.jpeg 2500 2500 26875
31298 517 product 0 26876 A 0 Okno-dachowe-RoofLITE-Slim-Vent-drewniane-wentylowane-78x118_2.jpg 2500 2500 26876
31299 517 product 0 26877 A 0 Okno-dachowe-RoofLITE-wentylacja.png 1920 1080 26877
31300 517 product 0 26878 A 0 Rooflite-Slim-Vent.jpg 1511 850 26878
31302 523 product 0 26880 A 0 Okno-dachowe-RoofLITE-Solid-Pine-drewniane-78x118-cm_2.jpg 2000 2000 26880
31303 523 product 0 26881 A 0 Okno-dachowe-RoofLITE-szyba-hartowana-powloka-niskoemisyjna.png 1920 1080 26881
31304 523 product 0 26882 A 0 Okno-dachowe-RoofLITE-uszczelka-obwiedniowa.png 1920 1080 26882
31305 523 product 0 26883 A 0 Okno-dachowe-RoofLITE-zawiasy.png 1920 1080 26883
31306 523 product 0 26884 A 0 RoofLITE-Solid-PINE.jpg 1503 831 26884
31661 9822 product 0 27239 A 0 118584-01-L.jpg 1024 768 27239
31662 9822 product 0 27240 A 0 119096-01-XXL.jpg 1024 768 27240
31663 9822 product 0 27241 A 0 120001-01-XXL.jpg 1024 766 27241
31664 9822 product 0 27242 A 0 1.png 1347 909 27242
31665 9822 product 0 27243 A 0 2.png 1242 888 27243
31666 9822 product 0 27244 A 0 119162-01-XXL.jpg 1024 768 27244
31667 9822 product 0 27245 A 0 118936-01-XXL.jpg 768 1024 27245
31668 9822 product 0 27246 A 0 119134-01-XXL.jpg 1024 768 27246
31669 9822 product 0 27247 A 0 119151-01-XXL.jpg 1024 682 27247
31670 9822 product 0 27248 A 0 119057-01-XXL.jpg 1024 768 27248
31671 9822 product 0 27249 A 0 119213-01-XXL.jpg 768 1024 27249
12625 8894 product 0 8553 A 1 VELUX_GPU_006140448603753b6c19596221.jpg 1024 682 8553
12626 8894 product 0 8554 A 2 VELUX_GPU_003140448603753b6c1959fc69.jpg 1024 768 8554
12627 8894 product 0 8555 A 3 VELUX_GPU_001140448603753b6c195a9b25.jpg 1024 768 8555
12624 8894 product 0 8552 A 4 VELUX_GPU_002140448603753b6c1958b49b.jpg 768 1024 8552