SELECT 
  `F`.`path`, 
  `PI`.`product_id`, 
  `PI`.`alt` 
FROM 
  `cscart_products__images` AS `PI` 
  LEFT JOIN `files` AS `F` ON `PI`.`watermark_small_file_id` = `F`.`id` 
WHERE 
  `PI`.`product_id` IN (28972, 28974, 30273, 28952, 14273)

Query time 0.00057

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "61.10"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "PI",
          "access_type": "range",
          "possible_keys": [
            "product_id"
          ],
          "key": "product_id",
          "used_key_parts": [
            "product_id"
          ],
          "key_length": "3",
          "rows_examined_per_scan": 51,
          "rows_produced_per_join": 51,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (28972,28974,30273,28952,14273))",
          "cost_info": {
            "read_cost": "19.11",
            "eval_cost": "5.10",
            "prefix_cost": "24.21",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "product_id",
            "watermark_small_file_id",
            "alt"
          ]
        }
      },
      {
        "table": {
          "table_name": "F",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "id"
          ],
          "key_length": "4",
          "ref": [
            "dev2.PI.watermark_small_file_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 51,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "31.79",
            "eval_cost": "5.10",
            "prefix_cost": "61.10",
            "data_read_per_join": "190K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_18b51b3ea31d_WhatsApp_Image_2024-01-12_at_10.01.07_gh2t-c2_vs5c-ll.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_327711b1ba77_WhatsApp_Image_2024-01-12_at_10.01.08__1__5tlt-oj_28g9-nl.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_5f231244b7f6_WhatsApp_Image_2024-01-12_at_10.01.08_lzm8-au_trax-l8.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_6ae8dc7dae41_WhatsApp_Image_2024-01-12_at_10.01.09__1__2brr-33_nibi-bj.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_1e3e9ccf1dc5_WhatsApp_Image_2024-01-12_at_10.01.09__2__c65i-8o_m78s-pl.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_05b4b8bbe21c_WhatsApp_Image_2024-01-12_at_10.01.09_erh6-xj_5mon-kt.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_5c96fc98ac7e_WhatsApp_Image_2024-01-12_at_10.01.10_qa4c-zv_k8je-px.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_7471f50e5c8a_WhatsApp_Image_2024-01-12_at_09.55.09__1__jpw7-g0_j5qa-ua.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_be0968de2dc4_WhatsApp_Image_2024-01-12_at_09.55.09__2__1frh-rm_k6yy-9e.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_6d47b8ce6e06_WhatsApp_Image_2024-01-12_at_09.55.09__3__y1nq-54_6s9r-q3.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_7f99e94a3da4_WhatsApp_Image_2024-01-12_at_09.55.09__4__arc8-5r_j5a7-bd.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_2e52c2d6c74a_WhatsApp_Image_2024-01-12_at_09.55.09__5__7dm3-38_ifzf-21.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_02c8eec70671_WhatsApp_Image_2024-01-12_at_09.55.09__6__pycu-m5_vsfi-w4.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_811298d4208c_WhatsApp_Image_2024-01-12_at_09.55.09__7__8amf-2c_oeov-bo.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_f866c3af25b7_WhatsApp_Image_2024-01-12_at_09.55.09__8__b4sf-cj_9yzd-nz.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_4b9d2d9ea04b_WhatsApp_Image_2024-01-12_at_09.55.09__9__4qsv-pf_jzcr-pz.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_cf48deb96a8f_WhatsApp_Image_2024-01-12_at_09.55.09__10__af7k-e9_2u86-4m.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_6cae171417a6_WhatsApp_Image_2024-01-12_at_09.55.09__11__ya1k-70_qddg-er.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_362f4b545679_WhatsApp_Image_2024-01-12_at_09.55.09_blzg-z3_olkn-n2.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_5466207b32e9_WhatsApp_Image_2024-01-12_at_10.01.06__1__r5wy-72_pd6m-f9.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_ab857f1b65b7_WhatsApp_Image_2024-01-12_at_10.01.06__2__1oq3-l5_rsay-tc.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_534f599637a9_WhatsApp_Image_2024-01-12_at_10.01.06_q9sk-2c_qh6k-kt.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_8c9e6b08a7fe_WhatsApp_Image_2024-01-12_at_10.01.07__1__111q-fz_x1zo-aj.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/14273_149cf8ab016e_WhatsApp_Image_2024-01-12_at_10.01.07__2__8nst-0t_3vvk-11.webp 14273
https://s3.timeweb.cloud/482029f9-prod/products__images/28952_9bc790f26d66_28953_dc48471d4675_0_18e09564c13e_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520142553.webp 28952
https://s3.timeweb.cloud/482029f9-prod/products__images/28952_31803cc8ecb0_28953_c1e2845ea72b_0_ac9afb29d596_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520142622.webp 28952
https://s3.timeweb.cloud/482029f9-prod/products__images/28952_053196498966_28953_ce24a84f0432_0_970f826489cb_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520142513.webp 28952
https://s3.timeweb.cloud/482029f9-prod/products__images/28952_24c004979667_28953_169d735a412f_0_e6d449366bab_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520142909.webp 28952
https://s3.timeweb.cloud/482029f9-prod/products__images/28952_f77d57659a2d_28953_918e1e478e05_0_156832495b2e_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520142930.webp 28952
https://s3.timeweb.cloud/482029f9-prod/products__images/28952_4757f2f111a8_28953_a604b2d1d418_0_40eab365351a_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520142950.webp 28952
https://s3.timeweb.cloud/482029f9-prod/products__images/28952_ffc83ca0e8c9_28953_6ba858f09f5f_0_37a9fe5654f5_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520140914.webp 28952
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_5e3cfbcabf9d_28973_90b4da3e31fc_0_0dcd5e69cc84_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520195654.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_da48650af5c6_28973_30b2030493e7_0_5a8314c2ada3_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520140546.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_fa43cc76adf3_28973_b50ff1206bcb_0_a6aee040dae7_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520195724.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_7dc3598fa2ec_28973_77c289666446_0_4eb3fae71b78_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520195740.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_4c472e125363_28973_6c95dac69007_0_9acde70c8968_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520140613.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_a928e6da79b6_28973_896100d4348b_0_97fd7fb02299_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520195756.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_a033c5f1e46c_28973_736a8028943b_0_ea408229f055_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520195813.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_5c84e9d18db2_28973_460e295f20c8_0_4cb94836b6db_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520140650.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_f9c682faf513_28975_2bb25901dafb_0_003ca094277b_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520140949.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_a059ec353961_28975_6287d313af80_0_a7f6494ac261_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520141034.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_4d4f7317cf13_28975_a2b0552979d4_0_887125e1a697_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520141059.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_2969f5edf84b_28975_0b26e904ded0_0_9fe71297bf0e_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520141122.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_11c5e39a2d86_28975_2348ae91c71a_0_a5e6ac8389b9_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520141205.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_958411c4cbcc_28975_9af6c69e3e27_0_82171a2e4244_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520141330.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_42d621b94e60_28975_fa5808f02559_0_61be826a80ef_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520141144.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_e89e1cbe897d_28975_c47ced63b0e2_0_cffa731113f7_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520141230.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/30273_bc76f3baca92_30274_a89f5890367a_0_c480481191c5_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520195841.webp 30273
https://s3.timeweb.cloud/482029f9-prod/products__images/30273_2fc489d957c7_30274_0934e56faadd_0_e32b0e918716_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520195916.webp 30273
https://s3.timeweb.cloud/482029f9-prod/products__images/30273_0281c0330b00_30274_f1cee3d64ac3_0_9454244a8fa4_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520195940.webp 30273
https://s3.timeweb.cloud/482029f9-prod/products__images/30273_49ddc432e754_30274_00ca0af9cd22_0_73dcc56b49ef_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520200002.webp 30273