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 (
    68974, 68973, 68972, 68971, 68970, 68969, 
    68968, 68967, 68966, 68965, 68964, 
    68963, 68962, 68961, 68960, 68959, 
    68958, 68957, 68956, 68955, 68954, 
    68953, 68952, 68951, 68950, 68949, 
    68948, 68947, 68946, 68945, 68321, 
    68290, 68289, 68288, 68286, 68285, 
    68284, 68283, 68282, 68281
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00101

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 5054283612585_pnkq-2y.jpg 1000 1000 70550 68281 product 74073 M 0 74073
0 5054283612585_wun5-fv.jpg 1000 1000 70551 68282 product 74074 M 0 74074
0 5054283612585_2hxb-69.jpg 1000 1000 70552 68283 product 74075 M 0 74075
0 5054283612585_le51-74.jpg 1000 1000 70553 68284 product 74076 M 0 74076
0 5054283612585_s988-0g.jpg 1000 1000 70554 68285 product 74077 M 0 74077
0 5054283612585_0q4l-g7.jpg 1000 1000 70555 68286 product 74078 M 0 74078
0 5054283612585_1lyy-x5.jpg 1000 1000 70557 68288 product 74080 M 0 74080
0 5054283612585_8jjd-kq.jpg 1000 1000 70558 68289 product 74081 M 0 74081
0 5054283612585_id0r-m1.jpg 1000 1000 70559 68290 product 74082 M 0 74082
0 5054283663365.jpg 1000 1000 70590 68321 product 74113 M 0 74113
0 5054283736762.jpg 1000 1000 71215 68945 product 74738 M 0 74738
0 5054283736762_l90p-mb.jpg 1000 1000 71216 68946 product 74739 M 0 74739
0 5054283736762_kzez-m9.jpg 1000 1000 71217 68947 product 74740 M 0 74740
0 5054283736762_c0x5-u4.jpg 1000 1000 71218 68948 product 74741 M 0 74741
0 5054283736762_ktiv-vb.jpg 1000 1000 71219 68949 product 74742 M 0 74742
0 5054283736762_x0pk-sw.jpg 1000 1000 71220 68950 product 74743 M 0 74743
0 5054283736762_3e54-3s.jpg 1000 1000 71221 68951 product 74744 M 0 74744
0 5054283736762_gosu-of.jpg 1000 1000 71222 68952 product 74745 M 0 74745
0 5054283736762_40f1-6a.jpg 1000 1000 71223 68953 product 74746 M 0 74746
0 5054283736762_6r3p-ny.jpg 1000 1000 71224 68954 product 74747 M 0 74747
0 5054283736762_0kzq-4s.jpg 1000 1000 71225 68955 product 74748 M 0 74748
0 5054283736762_m86r-ca.jpg 1000 1000 71226 68956 product 74749 M 0 74749
0 5054283736762_kszc-nn.jpg 1000 1000 71227 68957 product 74750 M 0 74750
0 5054283736762_rro6-tu.jpg 1000 1000 71228 68958 product 74751 M 0 74751
0 5054283736762_gzlj-o9.jpg 1000 1000 71229 68959 product 74752 M 0 74752
0 5054283736762_ipti-fy.jpg 1000 1000 71230 68960 product 74753 M 0 74753
0 5054283736762_b16i-ti.jpg 1000 1000 71231 68961 product 74754 M 0 74754
0 5054283736762_tdbs-py.jpg 1000 1000 71232 68962 product 74755 M 0 74755
0 5054283736762_ggq4-nk.jpg 1000 1000 71233 68963 product 74756 M 0 74756
0 5054283736762_z4jl-o8.jpg 1000 1000 71234 68964 product 74757 M 0 74757
0 5054283736762_u6xn-pc.jpg 1000 1000 71235 68965 product 74758 M 0 74758
0 5054283736762_m1es-j7.jpg 1000 1000 71236 68966 product 74759 M 0 74759
0 5054283736762_bckm-5a.jpg 1000 1000 71237 68967 product 74760 M 0 74760
0 5054283736762_lmrb-re.jpg 1000 1000 71238 68968 product 74761 M 0 74761
0 5054283736762_vqif-c6.jpg 1000 1000 71239 68969 product 74762 M 0 74762
0 5054283736762_o6dl-u3.jpg 1000 1000 71240 68970 product 74763 M 0 74763
0 5054283736762_yg4d-8o.jpg 1000 1000 71241 68971 product 74764 M 0 74764
0 5054283736762_kk05-66.jpg 1000 1000 71242 68972 product 74765 M 0 74765
0 5054283736762_frt6-3k.jpg 1000 1000 71243 68973 product 74766 M 0 74766
0 5054283736762_kzb3-en.jpg 1000 1000 71244 68974 product 74767 M 0 74767