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 (28739, 28756, 28774, 28779, 28781)

Query time 0.00072

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "63.46"
    },
    "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": 53,
          "rows_produced_per_join": 53,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (28739,28756,28774,28779,28781))",
          "cost_info": {
            "read_cost": "19.81",
            "eval_cost": "5.30",
            "prefix_cost": "25.11",
            "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": 53,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "33.05",
            "eval_cost": "5.30",
            "prefix_cost": "63.46",
            "data_read_per_join": "197K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/28739_5769a83665e1_28846_fb39883c1310_%25D0%2598%25D0%25B7%25D0%25BE%25D0%25B1%25D1%2580%25D0%25B0%25D0%25B6%25D0%25B5%25D0%25BD%25D0%25B8%25D0%25B5%2520WhatsApp%25202024-09-12%2520%25D0%25B2%252011.04.12_53592c21.webp 28739
https://s3.timeweb.cloud/482029f9-prod/products__images/28739_56370228f799_28846_0477f3bef708_%25D0%2598%25D0%25B7%25D0%25BE%25D0%25B1%25D1%2580%25D0%25B0%25D0%25B6%25D0%25B5%25D0%25BD%25D0%25B8%25D0%25B5%2520WhatsApp%25202024-09-12%2520%25D0%25B2%252011.04.12_e7fe2185.webp 28739
https://s3.timeweb.cloud/482029f9-prod/products__images/28739_737365ef0a63_28846_11838451a335_%25D0%2598%25D0%25B7%25D0%25BE%25D0%25B1%25D1%2580%25D0%25B0%25D0%25B6%25D0%25B5%25D0%25BD%25D0%25B8%25D0%25B5%2520WhatsApp%25202024-09-12%2520%25D0%25B2%252011.04.12_07886a60.webp 28739
https://s3.timeweb.cloud/482029f9-prod/products__images/28739_375552106db3_28846_99e1eead8789_%25D0%2598%25D0%25B7%25D0%25BE%25D0%25B1%25D1%2580%25D0%25B0%25D0%25B6%25D0%25B5%25D0%25BD%25D0%25B8%25D0%25B5%2520WhatsApp%25202024-09-12%2520%25D0%25B2%252011.04.12_99f11e4a.webp 28739
https://s3.timeweb.cloud/482029f9-prod/products__images/28739_7cd7eac4d6a3_28846_df399e5f3518_%25D0%2598%25D0%25B7%25D0%25BE%25D0%25B1%25D1%2580%25D0%25B0%25D0%25B6%25D0%25B5%25D0%25BD%25D0%25B8%25D0%25B5%2520WhatsApp%25202024-09-12%2520%25D0%25B2%252011.04.12_8743d67f.webp 28739
https://s3.timeweb.cloud/482029f9-prod/products__images/28739_bd59f6fcbcc4_28846_82ed2a306fc6_%25D0%2598%25D0%25B7%25D0%25BE%25D0%25B1%25D1%2580%25D0%25B0%25D0%25B6%25D0%25B5%25D0%25BD%25D0%25B8%25D0%25B5%2520WhatsApp%25202024-09-12%2520%25D0%25B2%252011.04.12_a24c859b.webp 28739
https://s3.timeweb.cloud/482029f9-prod/products__images/28739_c65cd7893271_28846_34e34911511d_%25D0%2598%25D0%25B7%25D0%25BE%25D0%25B1%25D1%2580%25D0%25B0%25D0%25B6%25D0%25B5%25D0%25BD%25D0%25B8%25D0%25B5%2520WhatsApp%25202024-09-12%2520%25D0%25B2%252011.04.12_fe085e33.webp 28739
https://s3.timeweb.cloud/482029f9-prod/products__images/28739_6370c26b4bf2_28846_3f29c0f4af0d_%25D0%2598%25D0%25B7%25D0%25BE%25D0%25B1%25D1%2580%25D0%25B0%25D0%25B6%25D0%25B5%25D0%25BD%25D0%25B8%25D0%25B5%2520WhatsApp%25202024-09-12%2520%25D0%25B2%252011.04.12_6dcd70de.webp 28739
https://s3.timeweb.cloud/482029f9-prod/products__images/28739_b49246951242_28846_604568e57972_%25D0%2598%25D0%25B7%25D0%25BE%25D0%25B1%25D1%2580%25D0%25B0%25D0%25B6%25D0%25B5%25D0%25BD%25D0%25B8%25D0%25B5%2520WhatsApp%25202024-09-12%2520%25D0%25B2%252011.04.12_825cf8d1.webp 28739
https://s3.timeweb.cloud/482029f9-prod/products__images/28739_e672b851f932_28846_7b5bb0c23c52_%25D0%2598%25D0%25B7%25D0%25BE%25D0%25B1%25D1%2580%25D0%25B0%25D0%25B6%25D0%25B5%25D0%25BD%25D0%25B8%25D0%25B5%2520WhatsApp%25202024-09-12%2520%25D0%25B2%252011.04.12_29e7829c.webp 28739
https://s3.timeweb.cloud/482029f9-prod/products__images/28739_bafa164d6b0e_28846_1469be293b62_%25D0%2598%25D0%25B7%25D0%25BE%25D0%25B1%25D1%2580%25D0%25B0%25D0%25B6%25D0%25B5%25D0%25BD%25D0%25B8%25D0%25B5%2520WhatsApp%25202024-09-12%2520%25D0%25B2%252011.04.12_5604758c.webp 28739
https://s3.timeweb.cloud/482029f9-prod/products__images/28739_dbb012cc782e_28846_c1e3433a6d00_%25D0%2598%25D0%25B7%25D0%25BE%25D0%25B1%25D1%2580%25D0%25B0%25D0%25B6%25D0%25B5%25D0%25BD%25D0%25B8%25D0%25B5%2520WhatsApp%25202024-09-12%2520%25D0%25B2%252011.04.12_17222079.webp 28739
https://s3.timeweb.cloud/482029f9-prod/products__images/28756_dfa4d3024239_28776_bcab0c04d84d_28756_cbf74b45e621_28757_06105fe9377b_0_1091f98fa519_%25252525D0%25252525A1%25252525D0%25252525BD%25252525D0%25252525B8%25252525D0%25252525BC%25252525D0%25252525BE%25252525D0%25252525BA%2525252520%25252525D1%252525258D%25252525D0%25252525BA%25252525D1%2525252580%25252525D0%25252525B0%25252525D0%25252525BD%25252525D0%25252525B0%25252525202024-12-13%2525252520134924.webp 28756
https://s3.timeweb.cloud/482029f9-prod/products__images/28756_f591da068f3f_28776_4ee861a8da82_28756_58cb17d50237_28757_485a6d8de936_0_7002f0b7dedb_%25252525D0%25252525A1%25252525D0%25252525BD%25252525D0%25252525B8%25252525D0%25252525BC%25252525D0%25252525BE%25252525D0%25252525BA%2525252520%25252525D1%252525258D%25252525D0%25252525BA%25252525D1%2525252580%25252525D0%25252525B0%25252525D0%25252525BD%25252525D0%25252525B0%25252525202024-12-13%2525252520135004.webp 28756
https://s3.timeweb.cloud/482029f9-prod/products__images/28756_fe794ed47647_28776_46b8ed15313b_28756_cdc09faf8b93_28757_5ba6499fd850_0_70c286eb30a1_%25252525D0%25252525A1%25252525D0%25252525BD%25252525D0%25252525B8%25252525D0%25252525BC%25252525D0%25252525BE%25252525D0%25252525BA%2525252520%25252525D1%252525258D%25252525D0%25252525BA%25252525D1%2525252580%25252525D0%25252525B0%25252525D0%25252525BD%25252525D0%25252525B0%25252525202024-12-13%2525252520135120.webp 28756
https://s3.timeweb.cloud/482029f9-prod/products__images/28756_09ea42dba57c_28776_21c1a4484ef6_28756_85072930de51_28757_9972f3eb840b_0_96cfac6d0efb_%25252525D0%25252525A1%25252525D0%25252525BD%25252525D0%25252525B8%25252525D0%25252525BC%25252525D0%25252525BE%25252525D0%25252525BA%2525252520%25252525D1%252525258D%25252525D0%25252525BA%25252525D1%2525252580%25252525D0%25252525B0%25252525D0%25252525BD%25252525D0%25252525B0%25252525202024-12-13%2525252520135024.webp 28756
https://s3.timeweb.cloud/482029f9-prod/products__images/28756_97aa75a9cfe6_28776_2253458a8331_28756_2e1b6c356c55_28757_a6d2b9ead113_0_1182a95cbf06_%25252525D0%25252525A1%25252525D0%25252525BD%25252525D0%25252525B8%25252525D0%25252525BC%25252525D0%25252525BE%25252525D0%25252525BA%2525252520%25252525D1%252525258D%25252525D0%25252525BA%25252525D1%2525252580%25252525D0%25252525B0%25252525D0%25252525BD%25252525D0%25252525B0%25252525202024-12-13%2525252520135141.webp 28756
https://s3.timeweb.cloud/482029f9-prod/products__images/28756_10738f4c1218_28776_16501bec337c_28756_18d7372deca7_28757_025073cd4a92_0_fa47c218534f_%25252525D0%25252525A1%25252525D0%25252525BD%25252525D0%25252525B8%25252525D0%25252525BC%25252525D0%25252525BE%25252525D0%25252525BA%2525252520%25252525D1%252525258D%25252525D0%25252525BA%25252525D1%2525252580%25252525D0%25252525B0%25252525D0%25252525BD%25252525D0%25252525B0%25252525202024-12-13%2525252520135055.webp 28756
https://s3.timeweb.cloud/482029f9-prod/products__images/28756_ceb076a6909f_28776_2aa55afcbfb4_28756_14502c5674bb_28757_0f9411a61867_0_b39150cf7d3e_%25252525D0%25252525A1%25252525D0%25252525BD%25252525D0%25252525B8%25252525D0%25252525BC%25252525D0%25252525BE%25252525D0%25252525BA%2525252520%25252525D1%252525258D%25252525D0%25252525BA%25252525D1%2525252580%25252525D0%25252525B0%25252525D0%25252525BD%25252525D0%25252525B0%25252525202024-12-13%2525252520135224.webp 28756
https://s3.timeweb.cloud/482029f9-prod/products__images/28756_897e206ff057_28776_a343491f4571_28756_928d26a9f351_28757_0cc96bbce9e7_0_bf9b8928aeac_%25252525D0%25252525A1%25252525D0%25252525BD%25252525D0%25252525B8%25252525D0%25252525BC%25252525D0%25252525BE%25252525D0%25252525BA%2525252520%25252525D1%252525258D%25252525D0%25252525BA%25252525D1%2525252580%25252525D0%25252525B0%25252525D0%25252525BD%25252525D0%25252525B0%25252525202024-12-13%2525252520135245.webp 28756
https://s3.timeweb.cloud/482029f9-prod/products__images/28756_aa90101c7878_28776_d80afee68bf8_28756_900ed2337afd_28757_4ac43d2d83f5_0_722390712bc4_%25252525D0%25252525A1%25252525D0%25252525BD%25252525D0%25252525B8%25252525D0%25252525BC%25252525D0%25252525BE%25252525D0%25252525BA%2525252520%25252525D1%252525258D%25252525D0%25252525BA%25252525D1%2525252580%25252525D0%25252525B0%25252525D0%25252525BD%25252525D0%25252525B0%25252525202024-12-13%2525252520135305.webp 28756
https://s3.timeweb.cloud/482029f9-prod/products__images/28774_2f9f69afc82e_28775_cb41713f10ca_0_ec9a2161535a_%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-13%252520155522.webp 28774
https://s3.timeweb.cloud/482029f9-prod/products__images/28774_33c1689af753_28775_ce72cb955553_0_ffd827fc40db_%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-13%252520155630.webp 28774
https://s3.timeweb.cloud/482029f9-prod/products__images/28774_f291300c2fdd_28775_572c8f3ec13f_0_8aeb877f58f6_%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-13%252520155733.webp 28774
https://s3.timeweb.cloud/482029f9-prod/products__images/28774_fc3317f688bf_28775_839a5cfd59ec_0_ed67aabaa910_%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-13%252520155704.webp 28774
https://s3.timeweb.cloud/482029f9-prod/products__images/28774_0347e6995a50_28775_7ef9d2541270_0_7b5bee1dd78a_%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-13%252520155856.webp 28774
https://s3.timeweb.cloud/482029f9-prod/products__images/28774_c7bef052582d_28775_bda37f3b1841_0_72b25fed3985_%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-13%252520155819.webp 28774
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_4cbe7a98efad_28844_17f546088f0c_IMG_2470.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_9329c8bb44ce_28844_8296aeb09330_IMG_2471.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_2c22547b6c11_28844_77b89c764438_IMG_2472.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_662b9cc8a6d4_28844_c251df8bccfd_IMG_2473.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_ee7ea98d2ea6_28844_6aad3a2480eb_IMG_2474.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_c8b00f41d96b_28844_b103ad3c967c_IMG_2476.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_7f88fa541f05_28844_29ee63a0f89e_IMG_2475.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_5f0fc1344c70_28844_26e584704717_IMG_2477.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_0e61ecaef561_28844_afd7533bae31_IMG_2479.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_d7cec820797f_28844_1bad9117d1a6_IMG_2486.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_6a532111242e_28844_0d8c29a1b4f8_IMG_2480.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_8566bd7494e0_28844_b6046f610856_IMG_2485.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_0966942aa158_28844_49faf7c47dd9_IMG_2482.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_380038a904ed_28844_83c0035200d0_IMG_2481.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_1024c07cd6cc_28844_cb595f1e6395_IMG_2483.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28779_ac7d577cd043_28844_f5ffacbe29cc_IMG_2484.webp 28779
https://s3.timeweb.cloud/482029f9-prod/products__images/28781_130c01a873df_28839_8cd2181f075a_%25D0%25A1%25D0%25BD%25D0%25B8%25D0%25BC%25D0%25BE%25D0%25BA%2520%25D1%258D%25D0%25BA%25D1%2580%25D0%25B0%25D0%25BD%25D0%25B0%25202024-12-14%2520013618.webp 28781
https://s3.timeweb.cloud/482029f9-prod/products__images/28781_2232c6c625d1_28839_6a784a8fcd56_%25D0%25A1%25D0%25BD%25D0%25B8%25D0%25BC%25D0%25BE%25D0%25BA%2520%25D1%258D%25D0%25BA%25D1%2580%25D0%25B0%25D0%25BD%25D0%25B0%25202024-12-14%2520013544.webp 28781
https://s3.timeweb.cloud/482029f9-prod/products__images/28781_eb5f43cee397_28839_64dd5dec109e_%25D0%25A1%25D0%25BD%25D0%25B8%25D0%25BC%25D0%25BE%25D0%25BA%2520%25D1%258D%25D0%25BA%25D1%2580%25D0%25B0%25D0%25BD%25D0%25B0%25202024-12-14%2520013658.webp 28781
https://s3.timeweb.cloud/482029f9-prod/products__images/28781_8ab01ac12cc1_28839_5bfb505d4407_%25D0%25A1%25D0%25BD%25D0%25B8%25D0%25BC%25D0%25BE%25D0%25BA%2520%25D1%258D%25D0%25BA%25D1%2580%25D0%25B0%25D0%25BD%25D0%25B0%25202024-12-14%2520013639.webp 28781
https://s3.timeweb.cloud/482029f9-prod/products__images/28781_26bc249b3414_28839_d022397198ce_%25D0%25A1%25D0%25BD%25D0%25B8%25D0%25BC%25D0%25BE%25D0%25BA%2520%25D1%258D%25D0%25BA%25D1%2580%25D0%25B0%25D0%25BD%25D0%25B0%25202024-12-14%2520013804.webp 28781
https://s3.timeweb.cloud/482029f9-prod/products__images/28781_10a9bae144c3_28839_540b637e8c13_%25D0%25A1%25D0%25BD%25D0%25B8%25D0%25BC%25D0%25BE%25D0%25BA%2520%25D1%258D%25D0%25BA%25D1%2580%25D0%25B0%25D0%25BD%25D0%25B0%25202024-12-14%2520013826.webp 28781
https://s3.timeweb.cloud/482029f9-prod/products__images/28781_97b1b45cac79_28839_e73ac36f7ecf_%25D0%25A1%25D0%25BD%25D0%25B8%25D0%25BC%25D0%25BE%25D0%25BA%2520%25D1%258D%25D0%25BA%25D1%2580%25D0%25B0%25D0%25BD%25D0%25B0%25202024-12-14%2520013848.webp 28781
https://s3.timeweb.cloud/482029f9-prod/products__images/28781_6699338d8303_28839_7108432b6a2d_%25D0%25A1%25D0%25BD%25D0%25B8%25D0%25BC%25D0%25BE%25D0%25BA%2520%25D1%258D%25D0%25BA%25D1%2580%25D0%25B0%25D0%25BD%25D0%25B0%25202024-12-14%2520013719.webp 28781
https://s3.timeweb.cloud/482029f9-prod/products__images/28781_cfbbc01da728_28839_43359204022e_%25D0%25A1%25D0%25BD%25D0%25B8%25D0%25BC%25D0%25BE%25D0%25BA%2520%25D1%258D%25D0%25BA%25D1%2580%25D0%25B0%25D0%25BD%25D0%25B0%25202024-12-14%2520013908.webp 28781
https://s3.timeweb.cloud/482029f9-prod/products__images/28781_12b0ecbe7ed5_28839_00e56f266b20_%25D0%25A1%25D0%25BD%25D0%25B8%25D0%25BC%25D0%25BE%25D0%25BA%2520%25D1%258D%25D0%25BA%25D1%2580%25D0%25B0%25D0%25BD%25D0%25B0%25202024-12-14%2520013925.webp 28781