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 (
    67356, 67355, 67354, 67353, 67352, 67351, 
    67350, 67349, 67348, 67347, 67346, 
    67345, 67344, 67314, 67313, 76804, 
    76803, 76802, 76801, 76800, 76799, 
    76798, 76797, 76796, 76795, 76794, 
    67193, 67179, 67178, 67177, 67176, 
    67175, 67174, 67173, 67172, 67171, 
    67170, 67169, 67168, 67167
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00082

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 5054283413502_rox3-10.jpg 1000 1000 69431 67167 product 72954 M 0 72954
0 5054283413502_ikpu-od.jpg 1000 1000 69432 67168 product 72955 M 0 72955
0 5054283413502_0ac7-fs.jpg 1000 1000 69433 67169 product 72956 M 0 72956
0 5054283413502_dlen-6i.jpg 1000 1000 69434 67170 product 72957 M 0 72957
0 5054283413502_1090-5t.jpg 1000 1000 69435 67171 product 72958 M 0 72958
0 5054283413502_7xi4-0k.jpg 1000 1000 69436 67172 product 72959 M 0 72959
0 5054283413502_5j4u-et.jpg 1000 1000 69437 67173 product 72960 M 0 72960
0 5054283413502_7f4j-mk.jpg 1000 1000 69438 67174 product 72961 M 0 72961
0 5054283413502_b06q-oc.jpg 1000 1000 69439 67175 product 72962 M 0 72962
0 5054283413502_9qdj-rj.jpg 1000 1000 69440 67176 product 72963 M 0 72963
0 5054283413502_czgv-4h.jpg 1000 1000 69441 67177 product 72964 M 0 72964
0 5054283413502_g91l-3g.jpg 1000 1000 69442 67178 product 72965 M 0 72965
0 5054283413502_favj-ui.jpg 1000 1000 69443 67179 product 72966 M 0 72966
0 5054283582154.jpg 1000 1000 69457 67193 product 72980 M 0 72980
0 5054283581874.jpg 1000 1000 69578 67313 product 73101 M 0 73101
0 5054283581874_7svc-a3.jpg 1000 1000 69579 67314 product 73102 M 0 73102
0 5054283331400.jpg 1000 1000 69609 67344 product 73132 M 0 73132
0 5054283331400_d1jx-fa.jpg 1000 1000 69610 67345 product 73133 M 0 73133
0 5054283331400_8gxk-b5.jpg 1000 1000 69611 67346 product 73134 M 0 73134
0 5054283331400_bwvt-uf.jpg 1000 1000 69612 67347 product 73135 M 0 73135
0 5054283331400_6vpn-io.jpg 1000 1000 69613 67348 product 73136 M 0 73136
0 5054283331400_m5g4-p2.jpg 1000 1000 69614 67349 product 73137 M 0 73137
0 5054283331400_f34z-1j.jpg 1000 1000 69615 67350 product 73138 M 0 73138
0 5054283331400_aaz7-ua.jpg 1000 1000 69616 67351 product 73139 M 0 73139
0 5054283331400_d678-z1.jpg 1000 1000 69617 67352 product 73140 M 0 73140
0 5054283331400_o6xe-ug.jpg 1000 1000 69618 67353 product 73141 M 0 73141
0 5054283331400_3hmj-mc.jpg 1000 1000 69619 67354 product 73142 M 0 73142
0 5054283331400_l2fq-1h.jpg 1000 1000 69620 67355 product 73143 M 0 73143
0 5054283331400_9br9-il.jpg 1000 1000 69621 67356 product 73144 M 0 73144
0 5054284405476_4cm5-fw.jpg 1000 1000 79643 76794 product 83166 M 0 83166
0 5054284405476_fm3t-ay.jpg 1000 1000 79644 76795 product 83167 M 0 83167
0 5054284405476_agmn-c3.jpg 1000 1000 79645 76796 product 83168 M 0 83168
0 5054284405476_gvcx-05.jpg 1000 1000 79646 76797 product 83169 M 0 83169
0 5054284405476_542j-em.jpg 1000 1000 79647 76798 product 83170 M 0 83170
0 5054284405476_qizc-oe.jpg 1000 1000 79648 76799 product 83171 M 0 83171
0 5054284405476_930c-xb.jpg 1000 1000 79649 76800 product 83172 M 0 83172
0 5054284405476_b8sy-w5.jpg 1000 1000 79650 76801 product 83173 M 0 83173
0 5054284405476_1c0d-90.jpg 1000 1000 79651 76802 product 83174 M 0 83174
0 5054284405476_je4l-yi.jpg 1000 1000 79652 76803 product 83175 M 0 83175
0 5054284405476_8o17-0q.jpg 1000 1000 79653 76804 product 83176 M 0 83176