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 (
    40303, 40302, 40301, 40300, 40299, 40298, 
    40297, 79897, 39728, 39507, 39506, 
    39377, 39398, 39447, 39332, 39319, 
    39318, 39313, 39267, 39266, 39265, 
    39264, 39263, 39260, 39259, 39641, 
    39255, 39247, 39246, 39225, 39224, 
    39223, 39184, 39183, 39270, 39147, 
    39393, 39391, 39390, 39389, 39387, 
    39385, 39383, 39382, 39381, 39644, 
    39144, 39143, 39142, 39141, 39140, 
    39139, 39138, 39137, 39136, 39135, 
    39134, 39133, 39132, 39131, 39130, 
    39129, 39128, 39127, 39069, 39068, 
    39067, 39066, 39065, 39064, 79921, 
    39118, 39117, 39116, 39115, 39034, 
    70800, 70799, 70798, 70797
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00119

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 80 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 40494 39034 product 44017 M 0
0 40524 39064 product 44047 M 0
0 40525 39065 product 44048 M 0
0 40526 39066 product 44049 M 0
0 40527 39067 product 44050 M 0
0 40528 39068 product 44051 M 0
0 40529 39069 product 44052 M 0
0 40575 39115 product 44098 M 0
0 40576 39116 product 44099 M 0
0 40577 39117 product 44100 M 0
0 40578 39118 product 44101 M 0
0 40587 39127 product 44110 M 0
0 40588 39128 product 44111 M 0
0 40589 39129 product 44112 M 0
0 40590 39130 product 44113 M 0
0 40591 39131 product 44114 M 0
0 40592 39132 product 44115 M 0
0 40593 39133 product 44116 M 0
0 40594 39134 product 44117 M 0
0 40595 39135 product 44118 M 0
0 40596 39136 product 44119 M 0
0 40597 39137 product 44120 M 0
0 40598 39138 product 44121 M 0
0 40599 39139 product 44122 M 0
0 40600 39140 product 44123 M 0
0 40601 39141 product 44124 M 0
0 40602 39142 product 44125 M 0
0 40603 39143 product 44126 M 0
0 40604 39144 product 44127 M 0
0 40607 39147 product 44130 M 0
0 40644 39183 product 44167 M 0
0 40645 39184 product 44168 M 0
0 40684 39223 product 44207 M 0
0 40685 39224 product 44208 M 0
0 40686 39225 product 44209 M 0
0 40708 39246 product 44231 M 0
0 40709 39247 product 44232 M 0
0 40718 39255 product 44241 M 0
0 40722 39259 product 44245 M 0
0 40723 39260 product 44246 M 0
0 40726 39263 product 44249 M 0
0 40727 39264 product 44250 M 0
0 40728 39265 product 44251 M 0
0 40729 39266 product 44252 M 0
0 40730 39267 product 44253 M 0
0 40733 39270 product 44256 M 0
0 40776 39313 product 44299 M 0
0 40781 39318 product 44304 M 0
0 40782 39319 product 44305 M 0
0 40795 39332 product 44318 M 0
0 40840 39377 product 44363 M 0
0 40844 39381 product 44367 M 0
0 40845 39382 product 44368 M 0
0 40846 39383 product 44369 M 0
0 40848 39385 product 44371 M 0
0 40850 39387 product 44373 M 0
0 40852 39389 product 44375 M 0
0 40853 39390 product 44376 M 0
0 40854 39391 product 44377 M 0
0 40856 39393 product 44379 M 0
0 40861 39398 product 44384 M 0
0 40909 39447 product 44432 M 0
0 40968 39506 product 44491 M 0
0 40969 39507 product 44492 M 0
0 41109 39641 product 44632 M 0
0 41112 39644 product 44635 M 0
0 41196 39728 product 44719 M 0
0 41779 40297 product 45302 M 0
0 41780 40298 product 45303 M 0
0 41781 40299 product 45304 M 0
0 41782 40300 product 45305 M 0
0 41783 40301 product 45306 M 0
0 41784 40302 product 45307 M 0
0 41785 40303 product 45308 M 0
0 73527 70797 product 77050 M 0
0 73528 70798 product 77051 M 0
0 73529 70799 product 77052 M 0
0 73530 70800 product 77053 M 0
0 82796 79897 product 86319 M 0
0 82820 79921 product 86343 M 0