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 (
    92048, 92047, 92046, 92045, 92044, 92043, 
    92042, 92041, 92040, 92039, 92038, 
    92037, 92036, 92035, 92034, 92033, 
    92032, 92031, 91994, 91786
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00057

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 5054285300671_vs5m-dp.jpg 1000 1000 94633 91786 product 98156 M 0 98156
0 VRF002_Cover_BloodyAmericans_GWR_NuroGL.png 800 800 94844 91994 product 98367 M 0 98367
0 Fireball_-_Best_Of_2019___2020.jpg 1400 1400 94882 92031 product 98405 M 0 98405
0 Fireball_-_Best_Of_2019___2020_f9jt-ht.jpg 1400 1400 94883 92032 product 98406 M 0 98406
0 Fireball_-_Best_Of_2019___2020_fyiw-k6.jpg 1400 1400 94884 92033 product 98407 M 0 98407
0 Fireball_-_Best_Of_2019___2020_glun-y6.jpg 1400 1400 94885 92034 product 98408 M 0 98408
0 Fireball_-_Best_Of_2019___2020_66xv-5u.jpg 1400 1400 94886 92035 product 98409 M 0 98409
0 Fireball_-_Best_Of_2019___2020_jwdu-i0.jpg 1400 1400 94887 92036 product 98410 M 0 98410
0 Fireball_-_Best_Of_2019___2020_am0r-ue.jpg 1400 1400 94888 92037 product 98411 M 0 98411
0 Fireball_-_Best_Of_2019___2020_kozg-d8.jpg 1400 1400 94889 92038 product 98412 M 0 98412
0 Fireball_-_Best_Of_2019___2020_jomr-nq.jpg 1400 1400 94890 92039 product 98413 M 0 98413
0 Fireball_-_Best_Of_2019___2020_61z5-tt.jpg 1400 1400 94891 92040 product 98414 M 0 98414
0 Fireball_-_Best_Of_2019___2020_h94i-i7.jpg 1400 1400 94892 92041 product 98415 M 0 98415
0 Fireball_-_Best_Of_2019___2020_xrs6-if.jpg 1400 1400 94893 92042 product 98416 M 0 98416
0 Fireball_-_Best_Of_2019___2020_01y5-4e.jpg 1400 1400 94894 92043 product 98417 M 0 98417
0 Fireball_-_Best_Of_2019___2020_wj1k-ja.jpg 1400 1400 94895 92044 product 98418 M 0 98418
0 Fireball_-_Best_Of_2019___2020_pxxg-z9.jpg 1400 1400 94896 92045 product 98419 M 0 98419
0 Fireball_-_Best_Of_2019___2020_pcpi-d2.jpg 1400 1400 94897 92046 product 98420 M 0 98420
0 Fireball_-_Best_Of_2019___2020_m2gn-a8.jpg 1400 1400 94898 92047 product 98421 M 0 98421
0 Fireball_-_Best_Of_2019___2020_kelq-eb.jpg 1400 1400 94899 92048 product 98422 M 0 98422