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.image_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.00128

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.image_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
1280 480 product 0 1238 A 0
1282 480 product 0 1240 A 0
7137 4939 product 0 3382 A 0
7138 4939 product 0 3383 A 0
7139 4939 product 0 3384 A 0
9562 7353 product 0 6440 A 0
11076 3315 product 0 7890 A 0
11077 3315 product 0 7891 A 0
11078 3315 product 0 7892 A 0
11812 4939 product 0 8286 A 0
12490 8878 product 0 8397 A 0
12885 4939 product 0 8798 A 0
12886 4939 product 0 8799 A 0
12887 4939 product 0 8800 A 0
12888 4939 product 0 8801 A 0
25989 10070 product 0 21564 A 0
27489 10172 product 0 23064 A 0
27490 10172 product 0 23065 A 0
28567 3318 product 0 24142 A 0
28568 3318 product 0 24143 A 0
28569 3318 product 0 24144 A 0
28570 3318 product 0 24145 A 0
28571 3318 product 0 24146 A 0
28572 3318 product 0 24147 A 0
29248 3321 product 0 24825 A 0
29249 3321 product 0 24826 A 0
29252 3321 product 0 24829 A 0
29253 3321 product 0 24830 A 0
29254 3321 product 0 24831 A 0
29255 3321 product 0 24832 A 0
30488 3318 product 0 26065 A 0
30489 3318 product 0 26066 A 0
30930 8295 product 0 26508 A 0
31202 10101 product 0 26780 A 0
31347 3321 product 0 26925 A 0
32489 3321 product 0 28067 A 0
32490 3321 product 0 28068 A 0
9560 7353 product 0 6438 A 1
12492 8878 product 0 8399 A 1
28038 10101 product 0 23613 A 1
28223 480 product 0 23798 A 1
30791 480 product 0 26369 A 1
31399 10070 product 0 26977 A 1
32515 8295 product 0 28093 A 1
12493 8878 product 0 8400 A 2
25990 10070 product 0 21565 A 2
25994 7353 product 0 21569 A 2
32519 8295 product 0 28097 A 2
12884 4939 product 0 8797 A 3
25991 10070 product 0 21566 A 3
25995 7353 product 0 21570 A 3
32480 10172 product 0 28058 A 3
32520 8295 product 0 28098 A 3
25992 10070 product 0 21567 A 4
27494 10172 product 0 23069 A 4
32513 8295 product 0 28091 A 4
12494 8878 product 0 8401 A 5
27495 10172 product 0 23070 A 5
30897 8295 product 0 26475 A 5
12491 8878 product 0 8398 A 6
27496 10172 product 0 23071 A 6
30896 8295 product 0 26474 A 6
12496 8878 product 0 8403 A 7
27497 10172 product 0 23072 A 7
30898 8295 product 0 26476 A 7
12498 8878 product 0 8405 A 8
27498 10172 product 0 23073 A 8
30899 8295 product 0 26477 A 8
12499 8878 product 0 8406 A 9
27499 10172 product 0 23074 A 9
32521 8295 product 0 28099 A 9
12500 8878 product 0 8407 A 10
30931 8295 product 0 26509 A 10
31355 8878 product 0 26933 A 10
31356 8878 product 0 26934 A 10