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 (
    69132, 69131, 69252, 69412, 69405, 69404, 
    68938, 68937, 68936, 68934, 68933, 
    68932, 68931, 68930, 68929, 68928, 
    68927, 68926, 68925, 68924, 68923, 
    68922, 68918, 68917, 68915, 68913, 
    68857, 68856, 68855, 68854, 68853, 
    68852, 68851, 68849, 68846, 68842, 
    68841, 68840, 68839, 69286
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00098

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 5054283472929.jpg 1000 1000 71109 68839 product 74632 M 0 74632
0 5054283472929_dp48-gg.jpg 1000 1000 71110 68840 product 74633 M 0 74633
0 5054283472929_bv7j-oq.jpg 1000 1000 71111 68841 product 74634 M 0 74634
0 5054283472929_3aue-ox.jpg 1000 1000 71112 68842 product 74635 M 0 74635
0 5054283472929_ak3i-3s.jpg 1000 1000 71116 68846 product 74639 M 0 74639
0 5054283472929_ejc2-sz.jpg 1000 1000 71119 68849 product 74642 M 0 74642
0 5054283472929_4ms7-5w.jpg 1000 1000 71121 68851 product 74644 M 0 74644
0 5054283472929_ze42-hq.jpg 1000 1000 71122 68852 product 74645 M 0 74645
0 5054283472929_tjqx-tm.jpg 1000 1000 71123 68853 product 74646 M 0 74646
0 5054283472929_t856-ay.jpg 1000 1000 71124 68854 product 74647 M 0 74647
0 5054283472929_6eg6-as.jpg 1000 1000 71125 68855 product 74648 M 0 74648
0 5054283472929_eff7-nk.jpg 1000 1000 71126 68856 product 74649 M 0 74649
0 5054283472929_3mz7-pg.jpg 1000 1000 71127 68857 product 74650 M 0 74650
0 5054283691405.jpg 1000 1000 71182 68913 product 74705 M 0 74705
0 5054283669541_ae7x-07.jpg 1000 1000 71184 68915 product 74707 M 0 74707
0 5054283669541_pttd-pu.jpg 1000 1000 71186 68917 product 74709 M 0 74709
0 5054283669541_u332-iy.jpg 1000 1000 71187 68918 product 74710 M 0 74710
0 5054283669541_ivmc-8c.jpg 1000 1000 71191 68922 product 74714 M 0 74714
0 5054283669541_63f9-5y.jpg 1000 1000 71192 68923 product 74715 M 0 74715
0 5054283669541_89hh-zl.jpg 1000 1000 71193 68924 product 74716 M 0 74716
0 5054283669541_gozu-lb.jpg 1000 1000 71194 68925 product 74717 M 0 74717
0 5054283669541_9pnd-ot.jpg 1000 1000 71195 68926 product 74718 M 0 74718
0 5054283669541_66pt-ix.jpg 1000 1000 71196 68927 product 74719 M 0 74719
0 5054283669541_6p0l-y6.jpg 1000 1000 71197 68928 product 74720 M 0 74720
0 5054283669541_k7g1-of.jpg 1000 1000 71198 68929 product 74721 M 0 74721
0 5054283669541_m44m-zp.jpg 1000 1000 71199 68930 product 74722 M 0 74722
0 5054283669541_x8fk-m3.jpg 1000 1000 71200 68931 product 74723 M 0 74723
0 5054283669541_dsa3-mt.jpg 1000 1000 71201 68932 product 74724 M 0 74724
0 5054283669541_0si1-eg.jpg 1000 1000 71202 68933 product 74725 M 0 74725
0 5054283669541_8yno-zc.jpg 1000 1000 71203 68934 product 74726 M 0 74726
0 5054283669541_z5pf-pb.jpg 1000 1000 71205 68936 product 74728 M 0 74728
0 5054283669541_j34t-6r.jpg 1000 1000 71206 68937 product 74729 M 0 74729
0 5054283669541_m7j4-9x.jpg 1000 1000 71207 68938 product 74730 M 0 74730
0 5054283616705_c9qv-3f.jpg 1000 1000 71402 69131 product 74925 M 0 74925
0 5054283616705_er2i-fe.jpg 1000 1000 71403 69132 product 74926 M 0 74926
0 5054283766998.jpg 1000 1000 71523 69252 product 75046 M 0 75046
0 5054283768220_ecju-0c.jpg 1000 1000 71558 69286 product 75081 M 0 75081
0 ODHS019_0oc1-8p.jpg 700 700 71678 69404 product 75201 M 0 75201
0 ODHS019_39qx-p1.jpg 700 700 71679 69405 product 75202 M 0 75202
0 5054283778656.jpg 1000 1000 71686 69412 product 75209 M 0 75209