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 = 'ru' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    2094, 1546, 1601, 371, 358, 449, 1540, 
    2082, 1516, 1545, 352, 2092
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00172

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
        "table": {
          "table_name": "cscart_images_links",
          "access_type": "range",
          "possible_keys": ["object_id"],
          "key": "object_id",
          "key_length": "81",
          "used_key_parts": ["object_id", "object_type", "type"],
          "rows": 48,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (2094,1546,1601,371,358,449,1540,2082,1516,1545,352,2092)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["image_id"],
      "ref": ["noframes_kz_new.cscart_images_links.detailed_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.detailed_id = cscart_images.image_id)"
    },
    "table": {
      "table_name": "cscart_common_descriptions",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "107",
      "used_key_parts": ["object_id", "lang_code", "object_holder"],
      "ref": ["noframes_kz_new.cscart_images.image_id", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_common_descriptions.object_id = cscart_images.image_id and cscart_common_descriptions.object_holder = 'images' and cscart_common_descriptions.lang_code = 'ru' and trigcond(cscart_images.image_id is not null))"
    }
  }
}

Result

image_id image_path image_x image_y is_high_res rf_original pair_id object_id object_type detailed_id type position alt images_image_id
0 горизонт__1__crop.jpg 1340 890 N горизонт__1__crop.jpg 10782 1545 product 8989 A 1 8989
0 origami-fotor-20240821135636_crop_mimn-3c.jpg 1340 890 N origami-fotor-20240821135636_crop_mimn-3c.jpg 10817 449 product 9024 A 1 9024
0 горизонт__1_.jpg 1340 893 N горизонт__1_.jpg 10843 1546 product 9050 A 1 9050
0 PRISMA_LOFT_DESIGN-fotor-20240821134141_crop_2vji-vj.jpg 1340 890 N PRISMA_LOFT_DESIGN-fotor-20240821134141_crop_2vji-vj.jpg 10869 2094 product 9076 A 4 9076
0 ORIGAMI-3_crop_ktrb-89.jpg 1340 890 N ORIGAMI-3_crop_ktrb-89.jpg 10818 449 product 9025 A 5 9025
0 apatite-2_x2gg-pe.jpg 1340 893 N apatite-2_x2gg-pe.jpg 10708 1601 product 8915 A 6 8915
0 DSC_3451-fotor-2024081816859_crop_nnq1-2g.jpg 1340 890 N DSC_3451-fotor-2024081816859_crop_nnq1-2g.jpg 10736 371 product 8943 A 6 8943
0 вертикаль-fotor-20240821133745_crop.jpg 1340 890 N вертикаль-fotor-20240821133745_crop.jpg 10875 1540 product 9082 A 6 9082
0 IMG_20240818_201714-fotor-20240821152116_crop_cmip-cp.jpg 1340 890 N IMG_20240818_201714-fotor-20240821152116_crop_cmip-cp.jpg 10709 1601 product 8916 A 7 8916
0 basalt-2_crop_ghwq-lg.jpg 1340 890 N basalt-2_crop_ghwq-lg.jpg 10726 2082 product 8933 A 7 8933
0 DSC_3442-fotor-2024081816533_crop_n4ym-ir.jpg 1340 890 N DSC_3442-fotor-2024081816533_crop_n4ym-ir.jpg 10737 371 product 8944 A 7 8944
0 2_crop_w5ea-fr.jpg 1340 890 N 2_crop_w5ea-fr.jpg 10762 1516 product 8969 A 7 8969
0 IMG_20240814_112722_crop.jpg 1340 890 N IMG_20240814_112722_crop.jpg 10768 2092 product 8975 A 7 8975
0 flerense_2_crop.jpg 1340 890 N flerense_2_crop.jpg 10783 1545 product 8990 A 7 8990
0 ORIGAMI-2_crop_ilym-61.jpg 1340 890 N ORIGAMI-2_crop_ilym-61.jpg 10819 449 product 9026 A 7 9026
0 plasa_2.jpg 1340 894 N plasa_2.jpg 10844 1546 product 9051 A 7 9051
0 горизонт.jpg 1340 754 N горизонт.jpg 10876 1540 product 9083 A 7 9083
0 IMG_20240818_201823-fotor-20240821145944_crop_17s6-rm.jpg 1340 890 N IMG_20240818_201823-fotor-20240821145944_crop_17s6-rm.jpg 10710 1601 product 8917 A 8 8917
0 BASALT-3_crop_nx5x-7k.jpg 1340 890 N BASALT-3_crop_nx5x-7k.jpg 10727 2082 product 8934 A 8 8934
0 DSC_3428-fotor-20240818155839_crop_eopu-46.jpg 1340 890 N DSC_3428-fotor-20240818155839_crop_eopu-46.jpg 10738 371 product 8945 A 8 8945
0 2.jpg 1340 811 N 2.jpg 10744 358 product 8951 A 8 8951
0 IMG_20240818_214104_crop_peky-2e.jpg 1340 890 N IMG_20240818_214104_crop_peky-2e.jpg 10763 1516 product 8970 A 8 8970
0 IMG_20240814_123219_crop.jpg 1340 890 N IMG_20240814_123219_crop.jpg 10769 2092 product 8976 A 8 8976
0 florense_3-fotor-20240821142222_crop.jpg 1340 890 N florense_3-fotor-20240821142222_crop.jpg 10784 1545 product 8991 A 8 8991
0 2_crop_tbcs-4g.jpg 1340 890 N 2_crop_tbcs-4g.jpg 10790 352 product 8997 A 8 8997
0 plasa_3-fotor-20240821135316_crop.jpg 1340 890 N plasa_3-fotor-20240821135316_crop.jpg 10845 1546 product 9052 A 8 9052
0 shabby_2_200x300_crop.jpg 1340 890 N shabby_2_200x300_crop.jpg 10877 1540 product 9084 A 8 9084
0 IMG_20240818_202957-fotor-20240821145826_crop_d0ag-p0.jpg 1340 890 N IMG_20240818_202957-fotor-20240821145826_crop_d0ag-p0.jpg 10711 1601 product 8918 A 9 8918
0 BASALT-4_crop_3h35-gv.jpg 1340 890 N BASALT-4_crop_3h35-gv.jpg 10728 2082 product 8935 A 9 8935
0 boreal_2.jpg 1340 893 N boreal_2.jpg 10745 358 product 8952 A 9 8952
0 IMG_20240818_214455_crop_14cj-98.jpg 1340 890 N IMG_20240818_214455_crop_14cj-98.jpg 10764 1516 product 8971 A 9 8971
0 IMG_20240814_121321_crop.jpg 1340 890 N IMG_20240814_121321_crop.jpg 10770 2092 product 8977 A 9 8977
0 133-_J2A1080-fotor-20240821142126_crop.jpg 1340 890 N 133-_J2A1080-fotor-20240821142126_crop.jpg 10791 352 product 8998 A 9 8998
0 DSC_3965-fotor-20240821134643_crop_wyb6-eh.jpg 1340 890 N DSC_3965-fotor-20240821134643_crop_wyb6-eh.jpg 10870 2094 product 9077 A 9 9077
0 shabby_3_200x300_crop.jpg 1340 890 N shabby_3_200x300_crop.jpg 10878 1540 product 9085 A 9 9085
0 IMG_20240818_202728-fotor-20240821145845_crop_3i82-k9.jpg 1340 890 N IMG_20240818_202728-fotor-20240821145845_crop_3i82-k9.jpg 10712 1601 product 8919 A 10 8919
0 basalt_2_njh0-xc.jpg 1340 893 N basalt_2_njh0-xc.jpg 10729 2082 product 8936 A 10 8936
0 boreal_3.jpg 1340 893 N boreal_3.jpg 10746 358 product 8953 A 10 8953
0 IMG_20240818_214322_crop_9r36-cq.jpg 1340 890 N IMG_20240818_214322_crop_9r36-cq.jpg 10765 1516 product 8972 A 10 8972
0 складка_ковра_crop.jpg 1340 890 N складка_ковра_crop.jpg 10771 2092 product 8978 A 10 8978
0 fresco_2_crop.jpg 1340 890 N fresco_2_crop.jpg 10792 352 product 8999 A 10 8999
0 DSC_3986-fotor-2024082113468_crop_rnxu-bk.jpg 1340 890 N DSC_3986-fotor-2024082113468_crop_rnxu-bk.jpg 10871 2094 product 9078 A 10 9078
0 basalt_3_fpgm-pw.jpg 1340 893 N basalt_3_fpgm-pw.jpg 10730 2082 product 8937 A 11 8937
0 IMG_20240818_214234_crop_xsoh-tt.jpg 1340 890 N IMG_20240818_214234_crop_xsoh-tt.jpg 10766 1516 product 8973 A 11 8973
0 IMG_20240814_121753_crop.jpg 1340 890 N IMG_20240814_121753_crop.jpg 10772 2092 product 8979 A 11 8979
0 fresco_3_crop.jpg 1340 890 N fresco_3_crop.jpg 10793 352 product 9000 A 11 9000
0 DSC_4027-fotor-20240821134538_crop_osmr-bh.jpg 1340 890 N DSC_4027-fotor-20240821134538_crop_osmr-bh.jpg 10872 2094 product 9079 A 11 9079
0 IMG_20240814_121723_crop.jpg 1340 890 N IMG_20240814_121723_crop.jpg 10773 2092 product 8980 A 12 8980
0 DSC_3898-fotor-2024082113451_crop_5b0f-yr.jpg 1340 890 N DSC_3898-fotor-2024082113451_crop_5b0f-yr.jpg 10873 2094 product 9080 A 12 9080