Review SQL from prisma for performance issues

[gmbronco]

Prisma is avoiding joins which results in complicated and slow queries, eg:

SELECT
    *
FROM
    "public"."PrismaPoolDynamicData"
WHERE
    (
        "public"."PrismaPoolDynamicData"."poolId",
        "public"."PrismaPoolDynamicData"."chain"
    ) IN (
        ($ 1, $ 2),
        ($ 3, $ 4),
        ($ 5, $ 6),
        ($ 7, $ 8),
        ($ 9, $ 10),
        ($ 11, $ 12),
        ($ 13, $ 14),
        ($ 15, $ 16),
        ($ 17, $ 18),
        ($ 19, $ 20),
        ($ 21, $ 22),
         ...
        ($ 1000, $ 1001),

this results in high CPU usage and its quite slow. Look into updating prisma to use joins, or refactoring the code to fetch all and process in JS.