Query Metrics

131 Database Queries
4 Different statements
32.19 ms Query time
0 Invalid entities
385 Managed entities

Grouped Statements

Show all queries

Time Count Info
30.00 ms
(93.21%)
128
SELECT t0.id AS id_1, t0.label AS label_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.is_start_fix AS is_start_fix_5, t0.is_end_fix AS is_end_fix_6, t0.date_interval AS date_interval_7, t0.steps AS steps_8 FROM date_range t0 WHERE t0.id = ?
Parameters:
[
  74
]
0.95 ms
(2.96%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_visible AS is_visible_2, c0_.description AS description_3, c0_.range_id AS range_id_4, c0_.image_id AS image_id_5 FROM chapter c0_ LEFT JOIN date_range d1_ ON (c0_.range_id = d1_.id) WHERE ( c0_.is_visible = 1 ) ORDER BY d1_.start_at ASC
Parameters:
[]
0.68 ms
(2.12%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_visible AS is_visible_2, p0_.color AS color_3, p0_.range_id AS range_id_4, p0_.image_id AS image_id_5 FROM period p0_ LEFT JOIN date_range d1_ ON (p0_.range_id = d1_.id) WHERE ( p0_.is_visible = 1 ) ORDER BY d1_.start_at ASC
Parameters:
[]
0.55 ms
(1.71%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4 FROM page t0
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\DateRange 128
App\Entity\Image 128
App\Entity\Chapter 124
App\Entity\Period 4
App\Entity\Page 1

Entities Mapping

Class Mapping errors
App\Entity\Period No errors.
App\Entity\DateRange No errors.
App\Entity\Image No errors.
App\Entity\Chapter No errors.
App\Entity\CharacterChapter No errors.
App\Entity\EventChapter No errors.
App\Entity\Theme No errors.
App\Entity\Page No errors.