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 (
    73214, 73213, 73212, 73211, 73210, 73209, 
    73208, 73207, 73206, 73205, 73204, 
    73203, 73202, 73201, 73200, 73199, 
    73198, 73197, 73196, 73195, 73623, 
    73622, 73621, 73620, 73619, 73618, 
    73617, 73616, 73615, 73614, 73613, 
    73612, 73509, 73285, 73241, 73408, 
    73402, 73401, 73337, 73336
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00060

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 76007 73195 product 79530 M 0
0 76008 73196 product 79531 M 0
0 76009 73197 product 79532 M 0
0 76010 73198 product 79533 M 0
0 76011 73199 product 79534 M 0
0 76012 73200 product 79535 M 0
0 76013 73201 product 79536 M 0
0 76014 73202 product 79537 M 0
0 76015 73203 product 79538 M 0
0 76016 73204 product 79539 M 0
0 76017 73205 product 79540 M 0
0 76018 73206 product 79541 M 0
0 76019 73207 product 79542 M 0
0 76020 73208 product 79543 M 0
0 76021 73209 product 79544 M 0
0 76022 73210 product 79545 M 0
0 76023 73211 product 79546 M 0
0 76024 73212 product 79547 M 0
0 76025 73213 product 79548 M 0
0 76026 73214 product 79549 M 0
0 76053 73241 product 79576 M 0
0 76097 73285 product 79620 M 0
0 76148 73336 product 79671 M 0
0 76149 73337 product 79672 M 0
0 76213 73401 product 79736 M 0
0 76214 73402 product 79737 M 0
0 76220 73408 product 79743 M 0
0 76321 73509 product 79844 M 0
0 76425 73612 product 79948 M 0
0 76426 73613 product 79949 M 0
0 76427 73614 product 79950 M 0
0 76428 73615 product 79951 M 0
0 76429 73616 product 79952 M 0
0 76430 73617 product 79953 M 0
0 76431 73618 product 79954 M 0
0 76432 73619 product 79955 M 0
0 76433 73620 product 79956 M 0
0 76434 73621 product 79957 M 0
0 76435 73622 product 79958 M 0
0 76436 73623 product 79959 M 0