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 (
    3321, 10101, 10172, 8878, 514, 10070, 
    8295, 3315, 7353, 4939, 480, 3318
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00222

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 37 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
1279 480 product 0 1237 A 0 vlx_ssl_001.jpg 511 767 1237
1280 480 product 0 1238 A 0 vlx_ssl_003.jpg 576 768 1238
1282 480 product 0 1240 A 0 vlx_ssl_002.jpg 767 511 1240
7137 4939 product 0 3382 A 0 fakro_arf_03.jpg 848 1271 3382
7138 4939 product 0 3383 A 0 fakro_arf_04.jpg 848 1139 3383
7139 4939 product 0 3384 A 0 fakro_arf_02.jpg 848 1271 3384
9562 7353 product 0 6440 A 0 fakro_amz_03.jpg 690 800 6440
11076 3315 product 0 7890 A 0 velux_bdx_02.jpg 280 280 7890
11077 3315 product 0 7891 A 0 velux_bdx_03.jpg 280 280 7891
11078 3315 product 0 7892 A 0 velux_solo.jpg 580 624 7892
11812 4939 product 0 8286 A 0 fakro_arf_05.jpg 848 565 8286
12490 8878 product 0 8397 A 0 118584-01-L.jpg 1024 768 8397
12885 4939 product 0 8798 A 0 fakro_arf_07.jpg 848 565 8798
12886 4939 product 0 8799 A 0 fakro_arf_08.jpg 848 1271 8799
12887 4939 product 0 8800 A 0 fakro_arf_10.jpg 848 565 8800
12888 4939 product 0 8801 A 0 fakro_arf_11.jpg 848 776 8801
25989 10070 product 0 21564 A 0 fakro_amz_04.jpg 600 401 21564
27489 10172 product 0 23064 A 0 118584-01-L.jpg 1024 768 23064
27490 10172 product 0 23065 A 0 ID10161764_XXL.jpg 1280 958 23065
28567 3318 product 0 24142 A 0 atr_mua_000.jpg 570 568 24142
28568 3318 product 0 24143 A 0 atr_mua_002_rqqj-hw.jpg 567 570 24143
28569 3318 product 0 24144 A 0 atr_mua_004.jpg 1600 1200 24144
28570 3318 product 0 24145 A 0 atr_mua_010.jpg 746 560 24145
28571 3318 product 0 24146 A 0 atr_mua_011.jpg 746 560 24146
28572 3318 product 0 24147 A 0 atr_mua_012.jpg 746 560 24147
29248 3321 product 0 24825 A 0 ATR_DUA_4208_all.jpg Blackout blind for VELUX roof window, white, perfect for bedroom 1200 1600 24825
29249 3321 product 0 24826 A 0 atr_dua_4212_naked.jpg Darkblue blind for VELUX roof window 1000 1000 24826
29252 3321 product 0 24829 A 0 ATR_DUA_4212_all.jpg Blackout blind for VELUX roof window, darkblue, perfect for bedroom 1200 1600 24829
29253 3321 product 0 24830 A 0 atr_dua_4217_naked.jpg Graphite blind for VELUX roof window 1000 1000 24830
29254 3321 product 0 24831 A 0 ATR_DUA_4217_all.jpg Blackout blind for VELUX roof window, graphite, perfect for bedroom 1200 1600 24831
29255 3321 product 0 24832 A 0 atr_dua_4219_naked.jpg Beige blind for VELUX roof window 1000 1000 24832
30488 3318 product 0 26065 A 0 atr_mua_004.jpg 1600 1200 26065
30489 3318 product 0 26066 A 0 atr_mua_002.jpg 567 570 26066
30930 8295 product 0 26508 A 0 Insektenschutz-Rollos_für_Dachfenster_.jpg 2400 3200 26508
31202 10101 product 0 26780 A 0 KMG-100K.jpg 1210 1613 26780
31347 3321 product 0 26925 A 0 ATR_DUA_4219_all_5dor-tg.jpg Blackout blind for VELUX roof window, beige, perfect for bedroom 1200 1600 26925
32489 3321 product 0 28067 A 0 atr_dua_4204_naked_x7s1-b2.jpg Light grey blind for VELUX roof window 1000 1000 28067
32490 3321 product 0 28068 A 0 atr_dua_4204_full_xhwi-r7.jpg Blackout blind for VELUX roof window, light grey, perfect for bedroom 1200 1600 28068
9560 7353 product 0 6438 A 1 fakro_amz_02.jpg 800 533 6438
12492 8878 product 0 8399 A 1 119096-01-XXL.jpg 1024 768 8399
28038 10101 product 0 23613 A 1 integra_kmg_100_unboxed_lhqk-ww.jpg 1012 577 23613
28223 480 product 0 23798 A 1 integra_kli_313_001_05w6-fr.png 220 220 23798
30791 480 product 0 26369 A 1 vlx_ssl_color.PNG 290 354 26369
31399 10070 product 0 26977 A 1 skymarkizw.jpg 1920 1920 26977
32515 8295 product 0 28093 A 1 ZIA_dakea_close_02.png 542 721 28093
12493 8878 product 0 8400 A 2 120001-01-XXL.jpg 1024 766 8400
25990 10070 product 0 21565 A 2 fakro_amz_02.jpg 800 533 21565
25994 7353 product 0 21569 A 2 fakro_amz_all_1.jpg 992 169 21569
32519 8295 product 0 28097 A 2 ZIA_dakea_close_01_1y3i-sh.png 542 721 28097
12884 4939 product 0 8797 A 3 fakro_arf_06.jpg 848 565 8797
25991 10070 product 0 21566 A 3 fakro_amz_04_5lko-sc.jpg 600 401 21566
25995 7353 product 0 21570 A 3 fakro_amz_all_2.jpg 363 167 21570
32480 10172 product 0 28058 A 3 ID10163459_XXL.jpg 1280 853 28058
32520 8295 product 0 28098 A 3 ZIA_NB_detail_01.png 542 721 28098
25992 10070 product 0 21567 A 4 fakro_amz_03.jpg 690 800 21567
27494 10172 product 0 23069 A 4 119162-01-XXL.jpg 1024 768 23069
32513 8295 product 0 28091 A 4 ZIA_packshot_01.png 500 500 28091
12494 8878 product 0 8401 A 5 119162-01-XXL.jpg 1024 768 8401
27495 10172 product 0 23070 A 5 118936-01-XXL.jpg 768 1024 23070
30897 8295 product 0 26475 A 5 insektenschutz-rollos-unboxing.png 900 974 26475
12491 8878 product 0 8398 A 6 118936-01-XXL.jpg 768 1024 8398
27496 10172 product 0 23071 A 6 119134-01-XXL.jpg 1024 768 23071
30896 8295 product 0 26474 A 6 insektenschutz-rollos-montagehinweise.png 1000 1150 26474
12496 8878 product 0 8403 A 7 119134-01-XXL.jpg 1024 768 8403
27497 10172 product 0 23072 A 7 119151-01-XXL.jpg 1024 682 23072
30898 8295 product 0 26476 A 7 insect_screen_montage_tips.png 1571 896 26476
12498 8878 product 0 8405 A 8 119151-01-XXL.jpg 1024 682 8405
27498 10172 product 0 23073 A 8 119057-01-XXL.jpg 1024 768 23073
30899 8295 product 0 26477 A 8 insect_screen_installation_tips.png 1573 624 26477
12499 8878 product 0 8406 A 9 119057-01-XXL.jpg 1024 768 8406
27499 10172 product 0 23074 A 9 119213-01-XXL.jpg 768 1024 23074
32521 8295 product 0 28099 A 9 ZIA_dakea_bedroom_01.png 482 721 28099
12500 8878 product 0 8407 A 10 119213-01-XXL.jpg 768 1024 8407
30931 8295 product 0 26509 A 10 Moustiquaire_pour_fenêtre_de_toit_.jpg 2400 1600 26509
31355 8878 product 0 26933 A 10 Velux-GLU-okno-dachowe.jpg 2000 1333 26933
31356 8878 product 0 26934 A 10 VELUX-GLU-0064.jpg 1280 960 26934