SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  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 = 'M' 
  AND cscart_images_links.object_id IN (
    65260, 65340, 65210, 64553, 65258, 65257, 
    65256, 65255, 65254, 65253, 65252, 
    65251, 65250, 65249, 65248, 65247, 
    65246, 65245, 65244, 65243, 65242, 
    65241, 65240, 65239, 65238, 65237, 
    65236, 65235, 65234, 65233, 65232, 
    65231, 65230, 65229, 65163, 65162, 
    65161, 65160, 65159, 65114
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00065

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 40 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 4 toolboxdigitalshop_dev.cscart_images_links.image_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where

Result

image_id image_path image_x image_y pair_id object_id object_type detailed_id type position alt images_image_id
0 66785 64553 product 70308 M 0
0 67359 65114 product 70882 M 0
0 67414 65159 product 70937 M 0
0 67415 65160 product 70938 M 0
0 67416 65161 product 70939 M 0
0 67417 65162 product 70940 M 0
0 67418 65163 product 70941 M 0
0 67465 65210 product 70988 M 0
0 67484 65229 product 71007 M 0
0 67485 65230 product 71008 M 0
0 67486 65231 product 71009 M 0
0 67487 65232 product 71010 M 0
0 67488 65233 product 71011 M 0
0 67489 65234 product 71012 M 0
0 67490 65235 product 71013 M 0
0 67491 65236 product 71014 M 0
0 67492 65237 product 71015 M 0
0 67493 65238 product 71016 M 0
0 67494 65239 product 71017 M 0
0 67495 65240 product 71018 M 0
0 67496 65241 product 71019 M 0
0 67497 65242 product 71020 M 0
0 67498 65243 product 71021 M 0
0 67499 65244 product 71022 M 0
0 67500 65245 product 71023 M 0
0 67501 65246 product 71024 M 0
0 67502 65247 product 71025 M 0
0 67503 65248 product 71026 M 0
0 67504 65249 product 71027 M 0
0 67505 65250 product 71028 M 0
0 67506 65251 product 71029 M 0
0 67507 65252 product 71030 M 0
0 67508 65253 product 71031 M 0
0 67509 65254 product 71032 M 0
0 67510 65255 product 71033 M 0
0 67511 65256 product 71034 M 0
0 67512 65257 product 71035 M 0
0 67513 65258 product 71036 M 0
0 67515 65260 product 71038 M 0
0 67595 65340 product 71118 M 0