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 (
    '30263', '19493', '19496', '19497', 
    '19495', '25666', '26492', '26979', 
    '27006', '27201', '25664'
  )

Query time 0.00074

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "33.30"
    },
    "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": 26,
          "rows_produced_per_join": 26,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in ('30263','19493','19496','19497','19495','25666','26492','26979','27006','27201','25664'))",
          "cost_info": {
            "read_cost": "11.86",
            "eval_cost": "2.60",
            "prefix_cost": "14.46",
            "data_read_per_join": "832"
          },
          "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": 26,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "16.24",
            "eval_cost": "2.60",
            "prefix_cost": "33.30",
            "data_read_per_join": "96K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/19493_2e666b1e587c_processed_3865fb4b0ee3afc4a77f02762b1997c3.webp 19493
https://s3.timeweb.cloud/482029f9-prod/products__images/19495_fec8137a89e4_processed_e86f6359006ccda227d11c5093b4aa9c.webp 19495
https://s3.timeweb.cloud/482029f9-prod/products__images/19496_21ae2bbac171_processed_24bec5b24ab6a9be1b68c13767521497.webp 19496
https://s3.timeweb.cloud/482029f9-prod/products__images/19497_4a9c349993e0_processed_f76a218c8796d787b7320b3d8299b494.webp 19497
https://s3.timeweb.cloud/482029f9-prod/products__images/25664_05f6f8bb4058_processed_lot_81207_20180126084323_oooaba.ru_6957_new_1.jpg.webp 25664
https://s3.timeweb.cloud/482029f9-prod/products__images/25664_07198273aa54_processed_lot_81207_20180126084334_oooaba.ru_6957_new_2.jpg.webp 25664
https://s3.timeweb.cloud/482029f9-prod/products__images/25664_dd7b452983b9_processed_lot_81207_20180126084351_oooaba.ru_6957_new_14.jpg.webp 25664
https://s3.timeweb.cloud/482029f9-prod/products__images/25664_e7dc24f31eec_processed_lot_81207_20180126084400_oooaba.ru_6957_new_8.jpg.webp 25664
https://s3.timeweb.cloud/482029f9-prod/products__images/25664_b430f41dbd31_processed_lot_81207_20180126084412_oooaba.ru_6957_new_18.jpg.webp 25664
https://s3.timeweb.cloud/482029f9-prod/products__images/25664_093770d21a6e_processed_lot_81207_20180126084424_oooaba.ru_6957_new_13.jpg.webp 25664
https://s3.timeweb.cloud/482029f9-prod/products__images/25666_49b413c34847_processed_lot_81204_20170123131423_oooaba.ru_6126_new_3.7_1.jpg.webp 25666
https://s3.timeweb.cloud/482029f9-prod/products__images/25666_2163cef7bd82_processed_lot_81204_20170123131441_oooaba.ru_6126_new_3.7_2.jpg.webp 25666
https://s3.timeweb.cloud/482029f9-prod/products__images/25666_ee4ffd0ff04e_processed_lot_81204_20170123131510_oooaba.ru_6126_new_3.7_11.jpg.webp 25666
https://s3.timeweb.cloud/482029f9-prod/products__images/25666_aff22798ccb6_processed_lot_81204_20170123131524_oooaba.ru_6126_new_3.7_10.jpg.webp 25666
https://s3.timeweb.cloud/482029f9-prod/products__images/26492_442c2133a840_processed_lot_95064_20170309102824_Higer_KLQ_6129Q__49______________________________________________________________________________________________________.jpg.webp 26492
https://s3.timeweb.cloud/482029f9-prod/products__images/26492_ee7a2f6c2098_processed_lot_95064_20170309102830_Higer_KLQ_6129Q__49_______________________________________________________________________________________________________1.jpg.webp 26492
https://s3.timeweb.cloud/482029f9-prod/products__images/26979_e5b3ca81c17e_processed_lot_87471_20160706165232_386cbb3c1b31a74b792ee81ea74c09a7.JPG.webp 26979
https://s3.timeweb.cloud/482029f9-prod/products__images/26979_753f909755a9_processed_lot_87471_20160706165250_84544791563cd4544293631923cbe9ba.JPG.webp 26979
https://s3.timeweb.cloud/482029f9-prod/products__images/26979_cd11d2ab0c90_processed_lot_87471_20160706165254_d7fbcd0f6c554c8f8dab57fa4f6b340c.JPG.webp 26979
https://s3.timeweb.cloud/482029f9-prod/products__images/26979_54a984916fb6_processed_lot_87471_20160706165300_f18a845b12283996249628ef558853e6.JPG.webp 26979
https://s3.timeweb.cloud/482029f9-prod/products__images/27006_f6a2980699e2_processed_lot_84946_20160414182533_2223885012.jpg.webp 27006
https://s3.timeweb.cloud/482029f9-prod/products__images/27006_a89bd8822777_processed_lot_84946_20160414182551_2223885793.jpg.webp 27006
https://s3.timeweb.cloud/482029f9-prod/products__images/27201_612e15d7d042_processed_lot_50842_20141007144336.webp 27201
https://s3.timeweb.cloud/482029f9-prod/products__images/27201_07f35ae7192d_processed_lot_50842_20141007144417.webp 27201
https://s3.timeweb.cloud/482029f9-prod/products__images/27201_105dc87b6eec_processed_lot_50842_20141007144452.webp 27201
https://s3.timeweb.cloud/482029f9-prod/products__images/30263_d82853dcb3b1_30264_32a64bcae70c_0_d31b8b0cc04e_%2525D1%252584%2525D0%2525BE%2525D1%252582%2525D0%2525BE%2525D0%2525BD%2525206122%25252C%252520%2525D0%2525B2%252520%2525D0%2525BD%2525D0%2525B0%2525D0%2525BB%2525D0%2525B8%2525D1%252587%2525D0%2525B8%2525D0%2525B8.webp 30263