GET https://grenaide.pommegrenade.fr/book/226

Query Metrics

7 Database Queries
5 Different statements
204.36 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

#▲ Time Info
1 25.98 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.company_id AS company_id_5 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 22.76 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.author AS author_3, t0.page_count AS page_count_4, t0.company_id AS company_id_5 FROM book t0 WHERE t0.id = ?
Parameters:
[
  "226"
]
3 43.96 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.book_id AS book_id_3 FROM book_content t0 WHERE t0.book_id = ? LIMIT 1
Parameters:
[
  226
]
4 47.25 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.model AS model_3, t0.effort AS effort_4, t0.chunk_index AS chunk_index_5, t0.chunk_count AS chunk_count_6, t0.partial_content AS partial_content_7, t0.failed AS failed_8, t0.updated_at AS updated_at_9, t0.book_id AS book_id_10, t0.prompt_id AS prompt_id_11 FROM book_version t0 WHERE t0.book_id = ?
Parameters:
[
  226
]
5 22.93 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.lang AS lang_4, t0.company_id AS company_id_5 FROM prompt t0 WHERE t0.id = ?
Parameters:
[
  9
]
6 21.02 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.book_id AS book_id_3 FROM book_content t0 WHERE t0.book_id = ? LIMIT 1
Parameters:
[
  226
]
7 20.45 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.book_id AS book_id_3 FROM book_content t0 WHERE t0.book_id = ? LIMIT 1
Parameters:
[
  226
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 1
App\Entity\Company 1
App\Entity\Book 1
App\Entity\BookContent 1
App\Entity\BookVersion 1
App\Entity\Prompt 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Company No errors.
App\Entity\Book No errors.
App\Entity\BookVersion No errors.
App\Entity\BookContent No errors.
App\Entity\Prompt No errors.