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 (
    351, 446, 360, 450, 311, 348, 353, 361, 
    1597, 1598, 349, 1536
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00165

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": 35,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (351,446,360,450,311,348,353,361,1597,1598,349,1536)"
        }
      }
    },
    "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 4015281fb2f4a8f402cc272b5377bbfb.jpg 726 484 N 3657 311 product 1865 A 1 1865
0 39fac54eb97b497cda0a7c6612836a5c.jpg 726 484 N 4208 446 product 2416 A 1 2416
0 горизонт_crop.jpg 1340 890 N горизонт_crop.jpg 10674 1536 product 8881 A 1 8881
0 DSC_2063-fotor-2024080216650_crop.jpg 1340 890 N DSC_2063-fotor-2024080216650_crop.jpg 10678 361 product 8885 A 1 8885
0 oscar-fotor-2024082113550_crop_yu9l-q4.jpg 1340 890 N oscar-fotor-2024082113550_crop_yu9l-q4.jpg 10831 450 product 9038 A 1 9038
0 agat-2_crop_as2s-sv.jpg 1340 890 N agat-2_crop_as2s-sv.jpg 11102 349 product 9309 A 1 9309
0 e8f9097716451650bc9ee8da55b27615.jpg 1280 535 N 3655 311 product 1863 A 2 1863
0 11f5ec6e7b0d5cf81589dee15c29624f.jpg 736 949 N 4209 446 product 2417 A 2 2417
0 OSCAR-3_crop_6dbh-bg.jpg 1340 890 N OSCAR-3_crop_6dbh-bg.jpg 10832 450 product 9039 A 2 9039
0 marble_ocean_crop.jpg 1340 890 N marble_ocean_crop.jpg 10956 1597 product 9163 A 2 9163
0 d93d48484dc474bf9589bcafd30e85f8.jpg 1280 853 N 3656 311 product 1864 A 3 1864
0 terrazzo_1_nag3-ys.jpg 6240 4375 N 5750 446 product 3959 A 3 3959
0 terrazzo_2.jpg 6720 4480 N 5716 446 product 3925 A 4 3925
0 terrazzo3_528f-at.jpg 6720 4480 N 5717 446 product 3926 A 5 3926
0 265d5b3f27bddec2af45e2b17db01810.jpg 1340 893 N 265d5b3f27bddec2af45e2b17db01810.jpg 10960 1598 product 9167 A 5 9167
0 OSCAR-2_crop_oidd-52.jpg 1340 890 N OSCAR-2_crop_oidd-52.jpg 10833 450 product 9040 A 6 9040
0 MARBLE_POWDER_3_crop.jpg 1340 890 N MARBLE_POWDER_3_crop.jpg 10961 1598 product 9168 A 6 9168
0 agat_2_jjgn-dh.jpg 1340 893 N agat_2_jjgn-dh.jpg 11103 349 product 9310 A 6 9310
0 basalt-2_crop.jpg 1340 890 N basalt-2_crop.jpg 10720 353 product 8927 A 7 8927
0 OSCAR_2_crop_cf9k-gu.jpg 1340 890 N OSCAR_2_crop_cf9k-gu.jpg 10834 450 product 9041 A 7 9041
0 MARBLE_OCEAN_3_crop.jpg 1340 890 N MARBLE_OCEAN_3_crop.jpg 10957 1597 product 9164 A 7 9164
0 agat_3_nyll-dh.jpg 1340 893 N agat_3_nyll-dh.jpg 11104 349 product 9311 A 7 9311
0 BASALT-3_crop.jpg 1340 890 N BASALT-3_crop.jpg 10721 353 product 8928 A 8 8928
0 2_lvkm-3h.jpg 1340 895 N 2_lvkm-3h.jpg 10748 348 product 8955 A 8 8955
0 2_crop.jpg 1340 890 N 2_crop.jpg 10756 360 product 8963 A 8 8963
0 2_crop_emej-1d.jpg 1340 890 N 2_crop_emej-1d.jpg 10799 351 product 9006 A 8 9006
0 OSCAR_3_crop_89b5-6o.jpg 1340 890 N OSCAR_3_crop_89b5-6o.jpg 10835 450 product 9042 A 8 9042
0 MARBLE_OCEAN_2_crop.jpg 1340 890 N MARBLE_OCEAN_2_crop.jpg 10958 1597 product 9165 A 8 9165
0 andromeda_2_crop_yxxw-z5.jpg 1340 890 N andromeda_2_crop_yxxw-z5.jpg 10675 1536 product 8882 A 9 8882
0 DSC_2109=-fotor-2024080216345_crop.jpg 1340 890 N DSC_2109=-fotor-2024080216345_crop.jpg 10679 361 product 8886 A 9 8886
0 BASALT-4_crop.jpg 1340 890 N BASALT-4_crop.jpg 10722 353 product 8929 A 9 8929
0 carrara_2.jpg 1340 893 N carrara_2.jpg 10749 348 product 8956 A 9 8956
0 IMG_20240818_214104_crop.jpg 1340 890 N IMG_20240818_214104_crop.jpg 10757 360 product 8964 A 9 8964
0 granite_2_crop_4mze-yl.jpg 1340 890 N granite_2_crop_4mze-yl.jpg 10800 351 product 9007 A 9 9007
0 andromeda_3-fotor-20240821144126_crop.jpg 1340 890 N andromeda_3-fotor-20240821144126_crop.jpg 10676 1536 product 8883 A 10 8883
0 DSC_2157=-fotor-2024080216733_crop.jpg 1340 890 N DSC_2157=-fotor-2024080216733_crop.jpg 10680 361 product 8887 A 10 8887
0 basalt_2.jpg 1340 893 N basalt_2.jpg 10723 353 product 8930 A 10 8930
0 carrara_3.jpg 1340 893 N carrara_3.jpg 10750 348 product 8957 A 10 8957
0 IMG_20240818_214455_crop.jpg 1340 890 N IMG_20240818_214455_crop.jpg 10758 360 product 8965 A 10 8965
0 granite_3_crop_xt22-j4.jpg 1340 890 N granite_3_crop_xt22-j4.jpg 10801 351 product 9008 A 10 9008
0 antique_2.jpg 1340 893 N antique_2.jpg 10681 361 product 8888 A 11 8888
0 basalt_3.jpg 1340 893 N basalt_3.jpg 10724 353 product 8931 A 11 8931
0 IMG_20240818_214322_crop.jpg 1340 890 N IMG_20240818_214322_crop.jpg 10759 360 product 8966 A 11 8966
0 anique_3.jpg 1340 893 N anique_3.jpg 10682 361 product 8889 A 12 8889
0 IMG_20240818_214234_crop.jpg 1340 890 N IMG_20240818_214234_crop.jpg 10760 360 product 8967 A 12 8967
0 BAMBOO_CUPRUM_1.jpg 1257 838 N 5705 311 product 3914 A 31 3914