GET https://preprod.citizenj7-music.fr/chants/dieu-de-gloire

Query Metrics

6 Database Queries
4 Different statements
2.31 ms Query time
0 Invalid entities
5 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.44 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_email AS site_email_3, t0.site_logo AS site_logo_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_phone AS site_phone_10, t0.site_youtube AS site_youtube_11, t0.site_verset AS site_verset_12, t0.site_versetverse AS site_versetverse_13, t0.site_presentation AS site_presentation_14, t0.site_facebook AS site_facebook_15, t0.site_apropos AS site_apropos_16 FROM setting t0 LIMIT 1
Parameters:
[]
2 0.51 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.tonalite AS tonalite_5, t0.tempo AS tempo_6, t0.duree AS duree_7, t0.mp3 AS mp3_8, t0.image AS image_9, t0.is_published AS is_published_10, t0.is_featured AS is_featured_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.music_style AS music_style_14, t0.video_id AS video_id_15, t0.tablature_id AS tablature_id_16 FROM chant t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "dieu-de-gloire"
]
3 0.33 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_email AS site_email_3, t0.site_logo AS site_logo_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_phone AS site_phone_10, t0.site_youtube AS site_youtube_11, t0.site_verset AS site_verset_12, t0.site_versetverse AS site_versetverse_13, t0.site_presentation AS site_presentation_14, t0.site_facebook AS site_facebook_15, t0.site_apropos AS site_apropos_16 FROM setting t0 LIMIT 1
Parameters:
[]
4 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.path AS path_4, t0.is_published AS is_published_5 FROM page t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
  "/chants"
]
5 0.29 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_email AS site_email_3, t0.site_logo AS site_logo_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_phone AS site_phone_10, t0.site_youtube AS site_youtube_11, t0.site_verset AS site_verset_12, t0.site_versetverse AS site_versetverse_13, t0.site_presentation AS site_presentation_14, t0.site_facebook AS site_facebook_15, t0.site_apropos AS site_apropos_16 FROM setting t0 LIMIT 1
Parameters:
[]
6 0.47 ms
SELECT t0.id AS id_1, t0.youtube_id AS youtube_id_2, t0.title AS title_3, t0.slug AS slug_4, t0.description AS description_5, t0.excerpt AS excerpt_6, t0.youtube_published_at AS youtube_published_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.duration AS duration_10, t0.is_published AS is_published_11, t0.is_featured AS is_featured_12, t0.video_type AS video_type_13, t0.is_short AS is_short_14, t0.music_style AS music_style_15, t0.thumbnail_url AS thumbnail_url_16, t0.view_count AS view_count_17, t0.category_id AS category_id_18, t0.parent_video_id AS parent_video_id_19, t0.chant_id AS chant_id_20 FROM video t0 WHERE t0.id = ?
Parameters:
[
  21
]

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\Setting 1
App\Entity\Chant 1
App\Entity\Video 1
App\Entity\Page 1
App\Entity\Category 1

Entities Mapping

Class Mapping errors
App\Entity\Setting No errors.
App\Entity\Chant No errors.
App\Entity\Video No errors.
App\Entity\Tablature No errors.
App\Entity\Page No errors.
App\Entity\Block No errors.
App\Entity\Category No errors.
App\Entity\Newsletter No errors.