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, 10945, 8864, 
    8880, 8875, 8869, 8886, 8891, 10211
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00147

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.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
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
12608 8891 product 0 8533 A 0
12609 8891 product 0 8534 A 0
12610 8891 product 0 8535 A 0
12611 8891 product 0 8536 A 0
12612 8891 product 0 8537 A 0
12636 8869 product 0 8566 A 0
12637 8869 product 0 8567 A 0
26125 8869 product 0 21700 A 0
27489 10172 product 0 23064 A 0
27490 10172 product 0 23065 A 0
27738 10211 product 0 23313 A 0
27739 10211 product 0 23314 A 0
27740 10211 product 0 23315 A 0
27741 10211 product 0 23316 A 0
27742 10211 product 0 23317 A 0
31982 10945 product 0 27560 A 0
12438 8860 product 0 8340 A 1
12449 8864 product 0 8355 A 1
12492 8878 product 0 8399 A 1
12578 8875 product 0 8498 A 1
32005 10945 product 0 27583 A 1
12450 8864 product 0 8356 A 2
12461 8860 product 0 8367 A 2
12493 8878 product 0 8400 A 2
12579 8875 product 0 8499 A 2
12647 8886 product 0 8579 A 2
31985 10945 product 0 27563 A 2
12437 8860 product 0 8339 A 3
12533 8864 product 0 8446 A 3
12580 8875 product 0 8500 A 3
12642 8886 product 0 8573 A 3
32006 10945 product 0 27584 A 3
32480 10172 product 0 28058 A 3
12474 8860 product 0 8380 A 4
12535 8864 product 0 8448 A 4
12582 8875 product 0 8502 A 4
12643 8886 product 0 8574 A 4
26118 8886 product 0 21693 A 4
27494 10172 product 0 23069 A 4
31986 10945 product 0 27564 A 4
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
27495 10172 product 0 23070 A 5
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
12464 8860 product 0 8370 A 7
12496 8878 product 0 8403 A 7
27497 10172 product 0 23072 A 7
12465 8860 product 0 8371 A 8
12498 8878 product 0 8405 A 8
27498 10172 product 0 23073 A 8
12466 8860 product 0 8372 A 9
12499 8878 product 0 8406 A 9
27499 10172 product 0 23074 A 9
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