GET https://back.boosttonlevel.com/api/sheet

Query Metrics

8 Database Queries
3 Different statements
6.03 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.53 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.rating AS rating_3, s0_.image AS image_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.slug AS slug_7, s0_.private AS private_8, s0_.user_id AS user_id_9 FROM sheet s0_ WHERE s0_.private = ? ORDER BY s0_.created_at DESC LIMIT 5
Parameters:
[
  0
]
2 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 INNER JOIN category_sheet ON t0.id = category_sheet.category_id WHERE category_sheet.sheet_id = ?
Parameters:
[
  97
]
3 0.34 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.avatar AS avatar_6, t0.rank AS rank_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.slug AS slug_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 INNER JOIN category_sheet ON t0.id = category_sheet.category_id WHERE category_sheet.sheet_id = ?
Parameters:
[
  96
]
5 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 INNER JOIN category_sheet ON t0.id = category_sheet.category_id WHERE category_sheet.sheet_id = ?
Parameters:
[
  24
]
6 0.34 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.avatar AS avatar_6, t0.rank AS rank_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.slug AS slug_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 0.94 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 INNER JOIN category_sheet ON t0.id = category_sheet.category_id WHERE category_sheet.sheet_id = ?
Parameters:
[
  48
]
8 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 INNER JOIN category_sheet ON t0.id = category_sheet.category_id WHERE category_sheet.sheet_id = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Sheet No errors.
App\Entity\User No errors.
App\Entity\Category No errors.
App\Entity\Comment No errors.
App\Entity\Reaction No errors.