pothos prisma N+1 query sample

$ yarn install
$ yarn dev

Problem

Prisma spits out many queries when requested with the following queries

{
  articles(first:30) {
    nodes {
      databaseId
      creator {
        databaseId
      }
    }
  }
}

prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE 1=1 ORDER BY `main`.`articles`.`id` ASC LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`articles`.`id`, `main`.`articles`.`creator_id` FROM `main`.`articles` WHERE (`main`.`articles`.`id` = ? AND 1=1) LIMIT ? OFFSET ?
prisma:query SELECT `main`.`creators`.`id` FROM `main`.`creators` WHERE `main`.`creators`.`id` IN (?) LIMIT ? OFFSET ?

touyu / pothos-prisma-query Goto Github PK

pothos-prisma-query's Introduction

pothos prisma N+1 query sample

Problem

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent