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 (
    96636, 96635, 96634, 96633, 96632, 96631, 
    96630, 96629, 96628, 96627, 96626, 
    95927, 95925, 95924, 95919, 95918, 
    95917, 95916, 95915, 95914, 95913, 
    95912, 95911, 95910, 95909, 95908, 
    95907, 95906, 95905, 95904, 95903, 
    95902, 95901, 95900, 95899, 96116, 
    96115, 95890, 95889, 95888
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00137

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 5054285877524_6u03-lz.jpg 1000 1000 98861 95888 product 102384 M 0 102384
0 5054285877524_6ksn-p7.jpg 1000 1000 98862 95889 product 102385 M 0 102385
0 5054285877524_30x1-vo.jpg 1000 1000 98863 95890 product 102386 M 0 102386
0 5054285876558.jpg 1000 1000 98872 95899 product 102395 M 0 102395
0 5054285876558_aw6h-0w.jpg 1000 1000 98873 95900 product 102396 M 0 102396
0 5054285876558_5eri-fc.jpg 1000 1000 98874 95901 product 102397 M 0 102397
0 5054285876558_i1ea-o2.jpg 1000 1000 98875 95902 product 102398 M 0 102398
0 5054285876558_tehn-kb.jpg 1000 1000 98876 95903 product 102399 M 0 102399
0 5054285876558_khd0-6f.jpg 1000 1000 98877 95904 product 102400 M 0 102400
0 5054285876558_aqrl-eq.jpg 1000 1000 98878 95905 product 102401 M 0 102401
0 5054285876558_tk7y-pv.jpg 1000 1000 98879 95906 product 102402 M 0 102402
0 5054285876558_ufqw-2k.jpg 1000 1000 98880 95907 product 102403 M 0 102403
0 5054285876558_vqcr-9i.jpg 1000 1000 98881 95908 product 102404 M 0 102404
0 5054285876558_7unl-z6.jpg 1000 1000 98882 95909 product 102405 M 0 102405
0 5054285876558_stq7-aq.jpg 1000 1000 98883 95910 product 102406 M 0 102406
0 5054285876558_javi-73.jpg 1000 1000 98884 95911 product 102407 M 0 102407
0 5054285876558_21lx-41.jpg 1000 1000 98885 95912 product 102408 M 0 102408
0 5054285876558_ydff-lp.jpg 1000 1000 98886 95913 product 102409 M 0 102409
0 5054285876558_zs8v-nm.jpg 1000 1000 98887 95914 product 102410 M 0 102410
0 5054285876558_xup3-nh.jpg 1000 1000 98888 95915 product 102411 M 0 102411
0 5054285876558_7arb-mm.jpg 1000 1000 98889 95916 product 102412 M 0 102412
0 5054285876558_v4vh-79.jpg 1000 1000 98890 95917 product 102413 M 0 102413
0 5054285876558_ovdb-3a.jpg 1000 1000 98891 95918 product 102414 M 0 102414
0 5054285876558_klig-w2.jpg 1000 1000 98892 95919 product 102415 M 0 102415
0 5054285655177.jpg 1000 1000 98897 95924 product 102420 M 0 102420
0 5054285655177_2ibo-gk.jpg 1000 1000 98898 95925 product 102421 M 0 102421
0 5054285837665.jpg 1000 1000 98900 95927 product 102423 M 0 102423
0 5054285920015.jpg 1000 1000 99091 96115 product 102614 M 0 102614
0 5054285920015_cvam-in.jpg 1000 1000 99092 96116 product 102615 M 0 102615
0 5054285937259.jpg 1000 1000 99607 96626 product 103130 M 0 103130
0 5054285937259_qmq1-4f.jpg 1000 1000 99608 96627 product 103131 M 0 103131
0 5054285937259_udrf-51.jpg 1000 1000 99609 96628 product 103132 M 0 103132
0 5054285937259_77q7-wa.jpg 1000 1000 99610 96629 product 103133 M 0 103133
0 5054285937259_pfo3-8x.jpg 1000 1000 99611 96630 product 103134 M 0 103134
0 5054285937259_akcm-4x.jpg 1000 1000 99612 96631 product 103135 M 0 103135
0 5054285937259_mgg7-fi.jpg 1000 1000 99613 96632 product 103136 M 0 103136
0 5054285937259_ymbh-ry.jpg 1000 1000 99614 96633 product 103137 M 0 103137
0 5054285937259_x34w-1j.jpg 1000 1000 99615 96634 product 103138 M 0 103138
0 5054285937259_snj5-t0.jpg 1000 1000 99616 96635 product 103139 M 0 103139
0 5054285937259_e6v1-1q.jpg 1000 1000 99617 96636 product 103140 M 0 103140