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 (
    515, 8686, 9862, 9863, 10125, 10124, 
    9859, 9858, 10384, 9857
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00205

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 26 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
4127 515 product 0 3097 A 0 VP70_refference_window.PNG 398 453 3097
11634 8686 product 0 8127 A 0 V82_refference_window.PNG 416 449 8127
28360 9859 product 0 23935 A 0 ec_geneo_007.jpg 630 672 23935
28362 9858 product 0 23937 A 0 ec_synego_002.jpg 630 691 23937
28368 10124 product 0 23943 A 0 ec_novel_002.jpg 422 450 23943
28375 9863 product 0 23950 A 0 ec_vigo_003.jpg 760 691 23950
28377 10125 product 0 23952 A 0 ec_livio_002.jpg 360 540 23952
28384 9862 product 0 23959 A 0 ec_ineo_003.jpg 540 743 23959
28388 9857 product 0 23963 A 0 ec_global_002.jpg 360 540 23963
29522 10384 product 0 25099 A 0 antracyt_fakturowany.png 318 500 25099
29531 10384 product 0 25108 A 0 6.png 581 500 25108
29532 10384 product 0 25109 A 0 impact_frame_69.png 575 514 25109
29533 10384 product 0 25110 A 0 impact_sash.png 637 571 25110
30029 10384 product 0 25606 A 0 ec_frame_and_sash_height.jpeg 700 749 25606
28356 9859 product 0 23931 A 1 ec_geneo_002.jpg 376 459 23931
28366 9858 product 0 23941 A 1 ec_synego_007.jpg 630 691 23941
28370 10124 product 0 23945 A 1 ec_novel_005.jpg 256 459 23945
28374 9863 product 0 23949 A 1 ec_vigo_002.jpg 259 450 23949
28379 10125 product 0 23954 A 1 ec_livio_005.jpg 256 459 23954
28385 9862 product 0 23960 A 1 ec_ineo_004.jpg 605 768 23960
28392 9857 product 0 23967 A 1 ec_global_007.jpg 630 691 23967
28396 9863 product 0 23971 A 1 ec_vigo_73md_59sx.jpeg 663 610 23971
28397 9863 product 0 23972 A 1 ec_vigo_73_md.jpeg 614 615 23972
28398 9863 product 0 23973 A 1 ec_vigo_z59_sx.jpeg 612 575 23973
30594 8686 product 0 26171 A 1 V82-modern-design-1024x724.jpg 1024 724 26171
30595 515 product 0 26172 A 1 VP70-1-1024x724.jpg 1024 724 26172
28358 9859 product 0 23933 A 2 ec_geneo_005.jpg 256 459 23933
28363 9858 product 0 23938 A 2 ec_synego_003.jpg 299 449 23938
28369 10124 product 0 23944 A 2 ec_novel_003.jpg 299 449 23944
28378 10125 product 0 23953 A 2 ec_livio_003.jpg 252 450 23953
28383 9862 product 0 23958 A 2 ec_ineo_002.jpg 2302 3110 23958
28389 9857 product 0 23964 A 2 ec_global_003.jpg 259 450 23964
28393 9862 product 0 23968 A 2 ec_ineo_z59_sx.jpeg 593 581 23968
28394 9862 product 0 23969 A 2 ec_ineo_71_md.jpeg 548 547 23969
28395 9862 product 0 23970 A 2 ec_ineo_z59_sx_fqto-rl.jpeg 593 581 23970
30596 8686 product 0 26173 A 2 realizacja_dom_1b-1024x877.jpg 1024 877 26173
30603 515 product 0 26180 A 2 realizacja_dom_2a-450x450.jpg 450 450 26180
13312 8686 product 0 8899 A 3 v82_02.png 717 603 8899
27995 515 product 0 23570 A 3 vp70_rt_001.jpg 680 915 23570
28357 9859 product 0 23932 A 3 ec_geneo_003.jpg 337 493 23932
28364 9858 product 0 23939 A 3 ec_synego_005.jpg 256 459 23939
28372 10124 product 0 23947 A 3 ec_novel_007.jpg 479 359 23947
28381 10125 product 0 23956 A 3 ec_livio_007.jpg 560 449 23956
28390 9857 product 0 23965 A 3 ec_global_005.jpg 256 459 23965
27610 8686 product 0 23185 A 4 veka_v82_section.gif 483 598 23185
27996 515 product 0 23571 A 4 vp70_rt_002.jpg 718 871 23571
28359 9859 product 0 23934 A 4 ec_geneo_006.jpg 522 449 23934
28365 9858 product 0 23940 A 4 ec_synego_006.jpg 522 449 23940
28371 10124 product 0 23946 A 4 ec_novel_006.jpg 522 449 23946
28380 10125 product 0 23955 A 4 ec_livio_006.jpg 522 449 23955
28391 9857 product 0 23966 A 4 ec_global_006.jpg 522 449 23966
28399 10125 product 0 23974 A 4 ec_livio_70md_58sx.jpeg 453 602 23974
28400 10125 product 0 23975 A 4 ec_livio_70_md.jpeg 590 513 23975
28401 10125 product 0 23976 A 4 ec_livio_z58_sx.jpeg 596 580 23976
28402 9857 product 0 23977 A 4 ec_global_68_sk60sx.jpeg 443 542 23977
28403 9857 product 0 23978 A 4 ec_global_68.jpeg 512 480 23978
28404 9857 product 0 23979 A 4 ec_global_sk60_sx.jpeg 508 537 23979
28405 9857 product 0 23980 A 4 ec_global_sk60_rx.jpeg 543 584 23980
28406 9858 product 0 23981 A 4 ec_synego_72md_sk59sx.jpeg 488 498 23981
28407 9858 product 0 23982 A 4 ec_synego_72_md.jpeg 576 510 23982
28408 9858 product 0 23983 A 4 ec_synego_z59_sx.jpeg 578 542 23983
28409 9858 product 0 23984 A 4 ec_synego_z59_rx.jpeg 611 540 23984
25979 515 product 0 21554 A 5 vetrex_ivt_2015.png 779 945 21554
25986 8686 product 0 21561 A 5 vetrex_ivt_2015_iti2-a2.png 779 945 21561
28410 9859 product 0 23985 A 5 ec_geneo_72.jpeg 602 512 23985
28412 9859 product 0 23987 A 6 ec_geneo_72_57.jpeg 552 575 23987
28411 9859 product 0 23986 A 7 ec_geneo_57ok.jpeg 594 531 23986