Skip to content

Instantly share code, notes, and snippets.

@capaj
Created March 28, 2023 07:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save capaj/a356757deeacde2479cd5c3dd75ce17a to your computer and use it in GitHub Desktop.
Save capaj/a356757deeacde2479cd5c3dd75ce17a to your computer and use it in GitHub Desktop.
knex vs prisma
limit $3 undefined +0ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 74277, 1 ] undefined +0ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +3ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 74400, 1 ] undefined +2ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +1ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 84433, 1 ] undefined +1ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +0ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 88374, 1 ] undefined +1ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +1ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 89165, 1 ] undefined +0ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +114ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 91438, 1 ] undefined +114ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +1ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 93217, 1 ] undefined +1ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +1ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 93484, 1 ] undefined +1ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +1ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 98371, 1 ] undefined +1ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +1ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 102288, 1 ] undefined +1ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +112ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 103682, 1 ] undefined +112ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +1ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 106184, 1 ] undefined +1ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +1ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 106406, 1 ] undefined +1ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +1ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 114417, 1 ] undefined +1ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +0ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 118624, 1 ] undefined +0ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +114ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 131299, 1 ] undefined +114ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +1ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 212780, 1 ] undefined +1ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +1ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 232009, 1 ] undefined +1ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +0ms
knex:bindings [ 'c609097c-9d6d-470f-b3f6-200f52e19fe4', 242949, 1 ] undefined +0ms
knex:query select "id" from "favorites" where "aws_user_id" = $1 and "post_id" = $2 limit $3 undefined +4ms
prisma:client Prisma Client call: +7s
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 74277
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 74277
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +7s
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 74400
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 74400
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 84433
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 84433
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 88374
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +1ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 88374
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +1ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 89165
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 89165
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 91438
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 91438
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 93217
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 93217
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 93484
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 93484
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 98371
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 98371
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 102288
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 102288
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 103682
},
select: {
id: true
}
}) +1ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 103682
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +1ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 106184
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 106184
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 106406
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 106406
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 114417
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 114417
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 118624
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 118624
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 131299
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 131299
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +1ms
prisma:client Prisma Client call: +1ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 212780
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 212780
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 232009
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 232009
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +1ms
prisma:client Prisma Client call: +1ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 242949
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 242949
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma:client Prisma Client call: +0ms
prisma:client prisma.favorites.findFirst({
where: {
aws_user_id: 'c609097c-9d6d-470f-b3f6-200f52e19fe4',
post_id: 254340
},
select: {
id: true
}
}) +0ms
prisma:client Generated request: +0ms
prisma:client query {
findFirstfavorites(where: {
aws_user_id: "c609097c-9d6d-470f-b3f6-200f52e19fe4"
post_id: 254340
}) {
id
}
}
+0ms
prisma:client:libraryEngine sending request, this.libraryStarted: true +0ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 74277
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +5s
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 98371
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +954ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 254340
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +580ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 118624
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +659ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 74400
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +4s
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 91438
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +583ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 114417
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +38ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 102288
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +267ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 93484
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +126ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 106184
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +36ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 88374
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +2ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 84433
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +24ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 242949
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +5ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 103682
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +21ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 232009
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +10ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 89165
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +4ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 131299
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +11ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 93217
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +5ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 106406
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +2ms
prisma SELECT
prisma "official"."favorites"."id"
prisma FROM
prisma "official"."favorites"
prisma WHERE
prisma (
prisma "official"."favorites"."aws_user_id" = "c609097c-9d6d-470f-b3f6-200f52e19fe4"
prisma AND "official"."favorites"."post_id" = 212780
prisma )
prisma LIMIT
prisma 1
prisma OFFSET
prisma 0 +1ms
of:gql operation GetTopUsersThisWeek +11s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment