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 (
    14819, 14818, 39047, 14808, 14807, 23244, 
    23237, 14795, 14720, 14713, 14730, 
    14728, 14726, 14723, 14722, 14787, 
    14701, 76378, 76377, 14677, 14663, 
    14662, 14661, 14660, 14659, 14658, 
    14657, 14656, 14654, 14653, 14652, 
    14651, 14649, 14648, 14647, 14646, 
    14645, 14644, 14643, 14642
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00094

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 5052653525695136245975451357c6a5af03.jpg 1000 1000 14655 14642 product 18178 M 0 18178
0 5052653525695136245975651357c6c07e8e.jpg 1000 1000 14656 14643 product 18179 M 0 18179
0 5052653525695136245975751357c6da27f9.jpg 1000 1000 14657 14644 product 18180 M 0 18180
0 5052653525695136245975951357c6f56f48.jpg 1000 1000 14658 14645 product 18181 M 0 18181
0 5052653525695136245976151357c710e962.jpg 1000 1000 14659 14646 product 18182 M 0 18182
0 5052653525695136245976251357c72b58fd.jpg 1000 1000 14660 14647 product 18183 M 0 18183
0 5052653525695136245976451357c7463ca7.jpg 1000 1000 14661 14648 product 18184 M 0 18184
0 5052653525695136245976651357c76125a2.jpg 1000 1000 14662 14649 product 18185 M 0 18185
0 5052653525695136245977151357c7b59ede.jpg 1000 1000 14664 14651 product 18187 M 0 18187
0 5052653525695136245977351357c7d08d88.jpg 1000 1000 14665 14652 product 18188 M 0 18188
0 5052653525695136245977451357c7eb1e0c.jpg 1000 1000 14666 14653 product 18189 M 0 18189
0 5052653525695136245977651357c805af0e.jpg 1000 1000 14667 14654 product 18190 M 0 18190
0 5052653556804136245978851357c8c30f72.jpg 1000 1000 14669 14656 product 18192 M 0 18192
0 5052653556804136245978951357c8dd6a7e.jpg 1000 1000 14670 14657 product 18193 M 0 18193
0 5052653556804136245979151357c8f8f955.jpg 1000 1000 14671 14658 product 18194 M 0 18194
0 5052653556804136245979351357c9144678.jpg 1000 1000 14672 14659 product 18195 M 0 18195
0 5052653556804136245979451357c92f0613.jpg 1000 1000 14673 14660 product 18196 M 0 18196
0 5052653556804136245979651357c949f36c.jpg 1000 1000 14674 14661 product 18197 M 0 18197
0 5052653556804136245979851357c964e2ba.jpg 1000 1000 14675 14662 product 18198 M 0 18198
0 5052653556804136245980051357c98057f9.jpg 1000 1000 14676 14663 product 18199 M 0 18199
0 5052653570039.jpg 1000 1000 14690 14677 product 18213 M 0 18213
0 5052653556958.jpg 1000 1000 14714 14701 product 18237 M 0 18237
0 5052653407120.jpg 1000 1000 14726 14713 product 18249 M 0 18249
0 5052653569996.jpg 1000 1000 14733 14720 product 18256 M 0 18256
0 5052653570428.jpg 1000 1000 14735 14722 product 18258 M 0 18258
0 50526535704281363064438513eb6763b9a3.jpg 1000 1000 14736 14723 product 18259 M 0 18259
0 50526535704281363064443513eb67b3522b.jpg 1000 1000 14739 14726 product 18262 M 0 18262
0 50526535704281363064446513eb67e81610.jpg 1000 1000 14741 14728 product 18264 M 0 18264
0 50526535704281363064449513eb681e1fb5.jpg 1000 1000 14743 14730 product 18266 M 0 18266
0 50526535299451363150819514007e35610f.jpg 1000 1000 14800 14787 product 18323 M 0 18323
0 5052653553292.jpg 1000 1000 14808 14795 product 18331 M 0 18331
0 5052653566186.jpg 1000 1000 14819 14807 product 18342 M 0 18342
0 5052653566186136349640851454dd888056.jpg 1000 1000 14820 14808 product 18343 M 0 18343
0 5052653578288.jpg 1000 1000 14830 14818 product 18353 M 0 18353
0 505265357828813636692245147f0e8e398f.jpg 1000 1000 14831 14819 product 18354 M 0 18354
0 5052653538145.jpg 1000 1000 23254 23237 product 26777 M 0 26777
0 5052653538145_l68e-y4.jpg 1000 1000 23261 23244 product 26784 M 0 26784
0 5054281388420.jpg 1000 1000 40507 39047 product 44030 M 0 44030
0 5054284395340.jpg 1000 1000 79226 76377 product 82749 M 0 82749
0 5054284395340_ttvz-o5.jpg 1000 1000 79227 76378 product 82750 M 0 82750