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.detailed_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 (
    95595, 95594, 95593, 95592, 95591, 95590, 
    95589, 95588, 95587, 95586, 95585, 
    95584, 95583, 95582, 95581, 95580, 
    95579, 95578, 95577, 95576, 95575, 
    95574, 95573, 95572, 95571, 94905, 
    95440, 95439, 94679, 94678, 94677, 
    94676, 94675, 94674, 94673, 94672, 
    94659, 94629, 94628, 94626
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00090

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.detailed_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 5054285694596_dfe9-nd.jpg 1000 1000 97514 94626 product 101037 M 0 101037
0 5054285742600.jpg 1000 1000 97516 94628 product 101039 M 0 101039
0 5054285742600_ny7o-cx.jpg 1000 1000 97517 94629 product 101040 M 0 101040
0 5054285720004.jpg 1000 1000 97547 94659 product 101070 M 0 101070
0 5054285803844.jpg 1000 1000 97560 94672 product 101083 M 0 101083
0 5054285803844_sdwd-gm.jpg 1000 1000 97561 94673 product 101084 M 0 101084
0 5054285803844_kkm6-pl.jpg 1000 1000 97562 94674 product 101085 M 0 101085
0 5054285803844_at2a-0n.jpg 1000 1000 97563 94675 product 101086 M 0 101086
0 5054285803844_384u-ef.jpg 1000 1000 97564 94676 product 101087 M 0 101087
0 5054285803844_5hym-nr.jpg 1000 1000 97565 94677 product 101088 M 0 101088
0 5054285803844_5b3b-wt.jpg 1000 1000 97566 94678 product 101089 M 0 101089
0 5054285803844_13py-sz.jpg 1000 1000 97567 94679 product 101090 M 0 101090
0 5054285830352.jpg 1000 1000 97797 94905 product 101320 M 0 101320
0 5054285875438.jpg 1000 1000 98361 95439 product 101884 M 0 101884
0 5054285875438_pwj1-5t.jpg 1000 1000 98362 95440 product 101885 M 0 101885
0 5054285880173.jpg 1000 1000 98493 95571 product 102016 M 0 102016
0 5054285880173_map3-c8.jpg 1000 1000 98494 95572 product 102017 M 0 102017
0 5054285880173_tmrc-h6.jpg 1000 1000 98495 95573 product 102018 M 0 102018
0 5054285880173_nr03-vb.jpg 1000 1000 98496 95574 product 102019 M 0 102019
0 5054285880173_zgen-rk.jpg 1000 1000 98497 95575 product 102020 M 0 102020
0 5054285880173_v9fb-dd.jpg 1000 1000 98498 95576 product 102021 M 0 102021
0 5054285880173_yl7x-vk.jpg 1000 1000 98499 95577 product 102022 M 0 102022
0 5054285880173_lc9v-it.jpg 1000 1000 98500 95578 product 102023 M 0 102023
0 5054285880173_6jzq-l4.jpg 1000 1000 98501 95579 product 102024 M 0 102024
0 5054285880173_8nc0-8l.jpg 1000 1000 98502 95580 product 102025 M 0 102025
0 5054285880173_b962-23.jpg 1000 1000 98503 95581 product 102026 M 0 102026
0 5054285880173_8jhj-zh.jpg 1000 1000 98504 95582 product 102027 M 0 102027
0 5054285880173_n2k8-hx.jpg 1000 1000 98505 95583 product 102028 M 0 102028
0 5054285880173_l6fa-pa.jpg 1000 1000 98506 95584 product 102029 M 0 102029
0 5054285880173_e4dm-al.jpg 1000 1000 98507 95585 product 102030 M 0 102030
0 5054285880173_os84-30.jpg 1000 1000 98508 95586 product 102031 M 0 102031
0 5054285880173_52zv-cq.jpg 1000 1000 98509 95587 product 102032 M 0 102032
0 5054285880173_ihuf-s4.jpg 1000 1000 98510 95588 product 102033 M 0 102033
0 5054285880173_k6rk-hx.jpg 1000 1000 98511 95589 product 102034 M 0 102034
0 5054285880173_herr-m6.jpg 1000 1000 98512 95590 product 102035 M 0 102035
0 5054285880173_d6di-rh.jpg 1000 1000 98513 95591 product 102036 M 0 102036
0 5054285880173_m9ch-0t.jpg 1000 1000 98514 95592 product 102037 M 0 102037
0 5054285880173_j1tc-bd.jpg 1000 1000 98515 95593 product 102038 M 0 102038
0 5054285880173_itgv-cr.jpg 1000 1000 98516 95594 product 102039 M 0 102039
0 5054285880173_boxc-t6.jpg 1000 1000 98517 95595 product 102040 M 0 102040