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 (
    10206, 10713, 9824, 9871, 9826, 396, 
    713, 10208, 556, 9854, 9825, 705
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00185

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 23 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
3095 396 product 0 2961 A 0 fakro_ftt_06.gif Der auf dem Markt niedrigste Uw-Wert von 0,58 W/m2K, kan man mit FAKRO FTT U8 und Eindeckrahmen EHV-AT Thermo erreichen. 200 200 2961
25147 9871 product 0 20734 A 0 fakro_ftpv_01.jpg Schwingfenster FTP R1 von außen 600 404 20734
25148 9871 product 0 20735 A 0 fakro_ftpv_02.jpg Schwingfenster FAKRO FTP R1 - Einbau mit Moduleindeckrahmen 600 420 20735
25149 9871 product 0 20736 A 0 fakro_ftpv_07138551024352953563a4ec4.jpg Dachfenster FTP R1 von FAKRO mit Möglichkeit von Innen- und Außenzubehör 424 600 20736
27703 10206 product 0 23278 A 0 VELUX_GGL_005140448468653b6bc4ef398e.jpg 1024 768 23278
27704 10206 product 0 23279 A 0 VELUX_GGL_007140448468753b6bc4f09a3a.jpg 1024 844 23279
27707 10206 product 0 23282 A 0 VELUX_GGL140448468753b6bc4f2ac9f.jpg 1024 768 23282
27709 10206 product 0 23284 A 0 VELUX_GGL_006140448468753b6bc4f3f921.jpg 1024 768 23284
27721 10208 product 0 23296 A 0 VELUX_GGU_004140442835453b5e04206331.jpg 1024 768 23296
27820 705 product 0 23395 A 0 Fakro_XDS1.png 268 188 23395
27821 705 product 0 23396 A 0 FAKRO_XDS.png 225 225 23396
28224 9854 product 0 23799 A 0 vlx_mhl_0p1.jpg Stoff der VELUX MML 5060 Elektro Markise 640 640 23799
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
31225 713 product 0 26803 A 0 zasilacz-fakro-zz60h-7.jpg 1152 864 26803
31226 713 product 0 26804 A 0 zasilacz-fakro-zz60h-3.jpg 1152 864 26804
31227 713 product 0 26805 A 0 zasilacz-fakro-zz60h-2.jpg 1152 864 26805
31228 713 product 0 26806 A 0 zasilacz-fakro-zz60h-1.jpg 1152 864 26806
31339 556 product 0 26917 A 0 133524-01-XXL.png 1088 725 26917
31340 556 product 0 26918 A 0 124248-06-XXL.jpg 1024 682 26918
31341 556 product 0 26919 A 0 135512-01-XXL.jpg 1024 683 26919
31342 556 product 0 26920 A 0 135525-01-XXL.jpg 956 454 26920
31343 556 product 0 26921 A 0 135526-07-XXL.jpg 1088 768 26921
31344 556 product 0 26922 A 0 135572-01-XXL.jpg 725 1088 26922
31345 556 product 0 26923 A 0 135671-01-L.jpg 725 1088 26923
31346 556 product 0 26924 A 0 136363-01-XXL.png 1088 725 26924
31673 9824 product 0 27251 A 0 118584-01-L_t70j-mz.jpg 1024 768 27251
31674 9824 product 0 27252 A 0 119096-01-XXL_98ut-dp.jpg 1024 768 27252
31675 9824 product 0 27253 A 0 119098-01-XXL_xkt8-kl.jpg 1024 768 27253
31676 9824 product 0 27254 A 0 120001-01-XXL_xsms-74.jpg 1024 766 27254
31677 9824 product 0 27255 A 0 119097-01-XXL_n9pu-jf.jpg 1024 768 27255
31678 9824 product 0 27256 A 0 119162-01-XXL_mcmn-v9.jpg 1024 768 27256
31679 9824 product 0 27257 A 0 118936-01-XXL_m5hh-yu.jpg 768 1024 27257
31680 9824 product 0 27258 A 0 119134-01-XXL_7wf0-40.jpg 1024 768 27258
31681 9824 product 0 27259 A 0 119151-01-XXL_m1s8-u0.jpg 1024 682 27259
31682 9824 product 0 27260 A 0 119057-01-XXL_dia3-dt.jpg 1024 768 27260
31683 9824 product 0 27261 A 0 119213-01-XXL_i055-n1.jpg 768 1024 27261
31949 10713 product 0 27527 A 0 velux-edz.jpg VELUX EDZ 220 220 27527
31950 10713 product 0 27528 A 0 velux-edw.jpg VELUX EDW 940 940 27528
31951 10713 product 0 27529 A 0 velux-edt.jpg VELUX EDT 940 940 27529
31952 10713 product 0 27530 A 0 velux-edj.jpg VELUX EDJ 220 220 27530
31953 10713 product 0 27531 A 0 velux-eds.jpg VELUX EDS 940 940 27531
31954 10713 product 0 27532 A 0 velux-edl.jpg VELUX EDL 940 940 27532
31955 10713 product 0 27533 A 0 velux-edn.jpg VELUX EDN 220 220 27533
31956 10713 product 0 27534 A 0 velux-edb.jpg VELUX EDB 940 940 27534
31957 10713 product 0 27535 A 0 velux-zwc.jpg VELUX ZWC 1500 743 27535
1081 396 product 0 1058 A 1 u8.jpg U8 - superenergieeffiziente 4-fach-Verglasung mit Bedampfungsschicht 348 299 1058
28229 9854 product 0 23804 A 1 vlx_mhl_0p2_ap5x-a2.jpg Sonnenschutzmaterial der VELUX MML Markise 354 354 23804
1082 396 product 0 1059 A 2 ftt-u8_04.jpg Schwingfenster FAKRO FTT U8 mit energieeffizienter 4-fach-Verglasung und höher versetzter Schwingachse 672 720 1059
28235 9854 product 0 23810 A 2 integra_kli_312_001_lpxc-rm.png VELUX INTEGRA Funk-Wandschalter für Innensonnenschutz 220 220 23810
28248 9854 product 0 23823 A 3 integra_kli_312_000.jpg 400 400 23823
25380 396 product 0 20967 A 4 fakro_ftt_u8_10.png Fakro Dachfenster FTT U8 mit ThermoPro-Technologie 1007 613 20967
28236 9854 product 0 23811 A 4 vlx_mhl_003.jpg MML Markisen sind passgenau auf Ihr VELUX Dachfenster abgestimmt 768 576 23811
1083 396 product 0 1060 A 5 ftt-u8_03.jpg Schwingfenster FTT U8 - gute Isolationseigenschaften und hohe Dichtheitsklasse 415 233 1060
28244 9854 product 0 23819 A 5 vlx_mhl_008_hl2q-om.jpg Elektro Markise für VELUX GGU Dachfenster 733 350 23819
28245 9854 product 0 23820 A 6 vlx_mml_001.jpg VELUX Hitzeschutz-Markisen für ein angenehmes Wohlfühlklima 768 576 23820
29454 396 product 0 25031 A 7 FTT_Thermo_12.jpg 2700 2068 25031