GET https://preprod.citizenj7-music.fr/chants/catalogue?direction=asc&page=1

Query Metrics

8 Database Queries
6 Different statements
2.70 ms Query time
0 Invalid entities
19 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
0.96 ms
(35.46%)
3
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:
[]
0.58 ms
(21.27%)
1
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.content AS content_3, c0_.tonalite AS tonalite_4, c0_.tempo AS tempo_5, c0_.duree AS duree_6, c0_.mp3 AS mp3_7, c0_.image AS image_8, c0_.is_published AS is_published_9, c0_.is_featured AS is_featured_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.music_style AS music_style_13, c0_.video_id AS video_id_14, c0_.tablature_id AS tablature_id_15 FROM chant c0_ WHERE c0_.is_published = ? AND c0_.id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  1
  2
  3
  4
  5
  6
  7
]
0.31 ms
(11.65%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.content AS content_3, t0.image AS image_4, t0.section AS section_5, t0.position AS position_6, t0.page_id AS page_id_7 FROM block t0 WHERE t0.page_id = ? ORDER BY t0.position ASC
Parameters:
[
  15
]
0.31 ms
(11.36%)
1
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/catalogue"
]
0.30 ms
(11.17%)
1
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM chant c0_ WHERE c0_.is_published = ?
Parameters:
[
  1
]
0.25 ms
(9.10%)
1
SELECT DISTINCT c0_.id AS id_0 FROM chant c0_ WHERE c0_.is_published = ? LIMIT 12
Parameters:
[
  1
]

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\Chant 7
App\Entity\Video 6
App\Entity\Block 3
App\Entity\Setting 1
App\Entity\Page 1
App\Entity\Tablature 1

Entities Mapping

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