GET https://biblios.zag-com2.fr/book?page=1

Query Metrics

23 Database Queries
5 Different statements
4.92 ms Query time
0 Invalid entities
23 Managed entities

Queries

Group similar statements

# Time Info
1 3.40 ms
SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.cover AS cover_3, b0_.edited_at AS edited_at_4, b0_.plot AS plot_5, b0_.status AS status_6, b0_.page_number AS page_number_7 FROM book b0_) dctrn_result LIMIT 10
Parameters:
[]
2 0.23 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.cover AS cover_3, b0_.edited_at AS edited_at_4, b0_.plot AS plot_5, b0_.status AS status_6, b0_.page_number AS page_number_7, b0_.editor_id AS editor_id_8, b0_.created_by_id AS created_by_id_9 FROM book b0_ WHERE b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  103
  109
  113
  125
  131
  2
  112
  114
  117
]
3 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
Parameters:
[
  1
]
4 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
Parameters:
[
  1
]
5 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
Parameters:
[
  2
]
6 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
Parameters:
[
  2
]
7 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
Parameters:
[
  103
]
8 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
Parameters:
[
  103
]
9 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
Parameters:
[
  109
]
10 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
Parameters:
[
  109
]
11 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
Parameters:
[
  112
]
12 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
Parameters:
[
  112
]
13 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
Parameters:
[
  113
]
14 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
Parameters:
[
  113
]
15 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
Parameters:
[
  114
]
16 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
Parameters:
[
  114
]
17 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
Parameters:
[
  117
]
18 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
Parameters:
[
  117
]
19 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
Parameters:
[
  125
]
20 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
Parameters:
[
  125
]
21 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
Parameters:
[
  131
]
22 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
Parameters:
[
  131
]
23 0.13 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.cover AS cover_3, b0_.edited_at AS edited_at_4, b0_.plot AS plot_5, b0_.status AS status_6, b0_.page_number AS page_number_7 FROM book b0_) dctrn_result) dctrn_table
Parameters:
[]

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\Book 10
App\Entity\Author 8
App\Entity\Editor 2
App\Entity\User 2
App\Entity\Comment 1

Entities Mapping

Class Mapping errors
App\Entity\Book No errors.
App\Entity\Editor No errors.
App\Entity\User No errors.
App\Entity\Comment No errors.
App\Entity\Author No errors.