Is UPDATE taking too long?

Question

SQLite

SQLITE base.
There is a table with a query in it, the id column, and a table with results in which there is an id from the first table, you need to update the column in the first table and record the number of repetitions of each id in the second table.
Schematically, it looks like this:

I made this kind of query, but it takes a very long time (23 seconds, 5000 rows in each table):

UPDATE [queries]
   SET [queries].[rezult] = 
       (SELECT COUNT( * ) FROM [searchRezult] WHERE [searchProdId] = [queries].[id])
 WHERE [queries].[id] = 
       (SELECT [searchProdId] FROM [searchRezult] WHERE [searchProdId] = [queries].[id]);