Query Metrics

12 Database Queries
8 Different statements
3.59 ms Query time
0 Invalid entities
16 Managed entities

Queries

Group similar statements

# Time Info
1 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.description AS description_4, t0.range_id AS range_id_5, t0.image_id AS image_id_6 FROM chapter t0 WHERE t0.id = ? AND (( t0.is_visible = 1 ))
Parameters:
[
  "79"
]
2 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.color AS color_4, t0.range_id AS range_id_5, t0.image_id AS image_id_6 FROM period t0 WHERE (( t0.is_visible = 1 ))
Parameters:
[]
3 0.30 ms
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:
[
  103
]
4 0.34 ms
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:
[
  2
]
5 0.29 ms
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:
[
  3
]
6 0.29 ms
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:
[
  8
]
7 0.24 ms
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:
[
  9
]
8 0.32 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_visible AS is_visible_3, t0.is_group AS is_group_4, t0.ordering AS ordering_5, t0.description AS description_6, t0.short_description AS short_description_7, t0.sources AS sources_8, t0.chapter_id AS chapter_id_9, t0.parent_id AS parent_id_10 FROM theme t0 WHERE t0.chapter_id = ? AND (( t0.is_visible = 1 )) ORDER BY t0.ordering ASC
Parameters:
[
  79
]
9 0.33 ms
SELECT t0.id AS id_1, t0.text_align AS text_align_2, t0.position_left AS position_left_3, t0.position_top AS position_top_4, t0.event_id AS event_id_5, t6.id AS id_7, t6.name AS name_8, t6.description AS description_9, t6.short_description AS short_description_10, t6.sources AS sources_11, t6.is_visible AS is_visible_12, t6.teaser AS teaser_13, t6.range_id AS range_id_14, t6.image_id AS image_id_15, t0.chapter_id AS chapter_id_16 FROM event_chapter t0 INNER JOIN event t6 ON t0.event_id = t6.id AND (( t6.is_visible = 1 )) WHERE t0.chapter_id = ?
Parameters:
[
  79
]
10 0.32 ms
SELECT t0.id AS id_1, t0.text_align AS text_align_2, t0.position_left AS position_left_3, t0.position_top AS position_top_4, t0.character_id AS character_id_5, t6.id AS id_7, t6.name AS name_8, t6.description AS description_9, t6.short_description AS short_description_10, t6.sources AS sources_11, t6.is_visible AS is_visible_12, t6.teaser AS teaser_13, t6.range_id AS range_id_14, t6.image_id AS image_id_15, t0.chapter_id AS chapter_id_16 FROM character_chapter t0 INNER JOIN `character` t6 ON t0.character_id = t6.id AND (( t6.is_visible = 1 )) WHERE t0.chapter_id = ?
Parameters:
[
  79
]
11 0.24 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.copyright AS copyright_4, t0.description AS description_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  149
]
12 0.24 ms
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 5
App\Entity\Image 5
App\Entity\Period 4
App\Entity\Chapter 1
App\Entity\Page 1

Entities Mapping

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