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 (
    94716, 94710, 94709, 94301, 94300, 94058, 
    93757, 94188, 93728, 93727, 93726, 
    93725, 93724, 93723, 93722, 93721, 
    93720, 93719, 93718, 93717
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00056

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 20 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 5054285718216_29tc-5z.jpg 1400 1400 96593 93717 product 100116 M 0 100116
0 5054285718216_l9xm-sr.jpg 1400 1400 96594 93718 product 100117 M 0 100117
0 5054285718216_g6ga-s3.jpg 1400 1400 96595 93719 product 100118 M 0 100118
0 5054285718216_msue-e8.jpg 1400 1400 96596 93720 product 100119 M 0 100119
0 5054285718216_o2z1-qm.jpg 1400 1400 96597 93721 product 100120 M 0 100120
0 5054285718216_jb68-nn.jpg 1400 1400 96598 93722 product 100121 M 0 100121
0 5054285718216_1nvt-y7.jpg 1400 1400 96599 93723 product 100122 M 0 100122
0 5054285718216_rjqn-ia.jpg 1400 1400 96600 93724 product 100123 M 0 100123
0 5054285718216_7og5-5a.jpg 1400 1400 96601 93725 product 100124 M 0 100124
0 5054285718216_i9q0-9v.jpg 1400 1400 96602 93726 product 100125 M 0 100125
0 5054285718216_bvh4-b6.jpg 1400 1400 96603 93727 product 100126 M 0 100126
0 5054285718216_vyjw-mw.jpg 1400 1400 96604 93728 product 100127 M 0 100127
0 5054285686447.jpg 1000 1000 96633 93757 product 100156 M 0 100156
0 1010000000305.jpg 1000 1000 96938 94058 product 100461 M 0 100461
0 5054285765333.jpg 1000 1000 97067 94188 product 100590 M 0 100590
0 shock_cover_master97.png 1200 1200 97182 94300 product 100705 M 0 100705
0 shock_cover_master98.png 1200 1200 97183 94301 product 100706 M 0 100706
0 5054285740828.jpg 1000 1000 97597 94709 product 101120 M 0 101120
0 5054285782675.jpg 1000 1000 97598 94710 product 101121 M 0 101121
0 5054285782675_fssh-tu.jpg 1000 1000 97604 94716 product 101127 M 0 101127