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 (
    8862, 8860, 10172, 8878, 8861, 10076, 
    10945, 8864, 9848, 8880, 8875, 8869
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00152

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 30 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
12442 8861 product 0 8345 A 0
12444 8862 product 0 8348 A 0
12445 8862 product 0 8349 A 0
12448 8864 product 0 8354 A 0
12473 8860 product 0 8379 A 0
12476 8862 product 0 8382 A 0
12477 8862 product 0 8383 A 0
12478 8862 product 0 8384 A 0
12479 8862 product 0 8385 A 0
12480 8862 product 0 8386 A 0
12481 8862 product 0 8387 A 0
12482 8862 product 0 8388 A 0
12483 8862 product 0 8389 A 0
12484 8862 product 0 8390 A 0
12490 8878 product 0 8397 A 0
12507 8880 product 0 8416 A 0
12508 8880 product 0 8417 A 0
12509 8880 product 0 8418 A 0
12510 8880 product 0 8419 A 0
12511 8880 product 0 8420 A 0
12512 8880 product 0 8421 A 0
12576 8875 product 0 8496 A 0
12636 8869 product 0 8566 A 0
12637 8869 product 0 8567 A 0
13592 9848 product 0 9179 A 0
13593 9848 product 0 9180 A 0
13594 9848 product 0 9181 A 0
13595 9848 product 0 9182 A 0
13597 9848 product 0 9184 A 0
26005 10076 product 0 21580 A 0
26125 8869 product 0 21700 A 0
27489 10172 product 0 23064 A 0
27490 10172 product 0 23065 A 0
31982 10945 product 0 27560 A 0
12438 8860 product 0 8340 A 1
12443 8861 product 0 8346 A 1
12449 8864 product 0 8355 A 1
12492 8878 product 0 8399 A 1
12578 8875 product 0 8498 A 1
27136 10076 product 0 22711 A 1
32005 10945 product 0 27583 A 1
12450 8864 product 0 8356 A 2
12452 8861 product 0 8358 A 2
12461 8860 product 0 8367 A 2
12493 8878 product 0 8400 A 2
12579 8875 product 0 8499 A 2
27137 10076 product 0 22712 A 2
31985 10945 product 0 27563 A 2
12437 8860 product 0 8339 A 3
12456 8861 product 0 8362 A 3
12533 8864 product 0 8446 A 3
12580 8875 product 0 8500 A 3
32006 10945 product 0 27584 A 3
32480 10172 product 0 28058 A 3
12454 8861 product 0 8360 A 4
12474 8860 product 0 8380 A 4
12535 8864 product 0 8448 A 4
12582 8875 product 0 8502 A 4
27494 10172 product 0 23069 A 4
31986 10945 product 0 27564 A 4
12455 8861 product 0 8361 A 5
12462 8860 product 0 8368 A 5
12494 8878 product 0 8401 A 5
12536 8864 product 0 8449 A 5
12577 8875 product 0 8497 A 5
26010 10076 product 0 21585 A 5
27495 10172 product 0 23070 A 5
31367 10076 product 0 26945 A 5
31368 10076 product 0 26946 A 5
31369 10076 product 0 26947 A 5
31370 10076 product 0 26948 A 5
31371 10076 product 0 26949 A 5
31372 10076 product 0 26950 A 5
31373 10076 product 0 26951 A 5
12453 8861 product 0 8359 A 6
12463 8860 product 0 8369 A 6
12491 8878 product 0 8398 A 6
12534 8864 product 0 8447 A 6
12581 8875 product 0 8501 A 6
27496 10172 product 0 23071 A 6
12457 8861 product 0 8363 A 7
12464 8860 product 0 8370 A 7
12496 8878 product 0 8403 A 7
27497 10172 product 0 23072 A 7
12458 8861 product 0 8364 A 8
12465 8860 product 0 8371 A 8
12498 8878 product 0 8405 A 8
27498 10172 product 0 23073 A 8
12459 8861 product 0 8365 A 9
12466 8860 product 0 8372 A 9
12499 8878 product 0 8406 A 9
27499 10172 product 0 23074 A 9
12460 8861 product 0 8366 A 10
12467 8860 product 0 8373 A 10
12500 8878 product 0 8407 A 10
31355 8878 product 0 26933 A 10
31356 8878 product 0 26934 A 10
12468 8860 product 0 8374 A 11
12469 8860 product 0 8375 A 12
12470 8860 product 0 8376 A 13
12471 8860 product 0 8377 A 14