GET https://preprod.citizenj7-music.fr/tablatures/tu-es-ma-lumiere

Query Metrics

9 Database Queries
7 Different statements
2.96 ms Query time
0 Invalid entities
12 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
0.92 ms
(30.96%)
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.41 ms
(13.95%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image AS image_4, t0.description AS description_5, t0.name AS name_6, t0.type AS type_7, t0.family AS family_8, t0.position AS position_9, t0.is_published AS is_published_10 FROM accord t0 INNER JOIN tablature_accord ON t0.id = tablature_accord.accord_id WHERE tablature_accord.tablature_id = ?
Parameters:
[
  1
]
0.37 ms
(12.39%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.tab_key AS tab_key_5, t0.difficulty AS difficulty_6, t0.pdf AS pdf_7, t0.image AS image_8, t0.is_published AS is_published_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_capo AS is_capo_12 FROM tablature t0 WHERE t0.slug = ? AND t0.is_published = ? LIMIT 1
Parameters:
[
  "tu-es-ma-lumiere"
  1
]
0.34 ms
(11.58%)
1
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.chant_id = ? AND t0.is_short = ? AND t0.is_published = ? ORDER BY t0.youtube_published_at DESC LIMIT 1
Parameters:
[
  2
  0
  1
]
0.32 ms
(10.80%)
1
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.chant_id = ? AND t0.is_short = ? AND t0.is_published = ? ORDER BY t0.youtube_published_at DESC
Parameters:
[
  2
  1
  1
]
0.30 ms
(10.29%)
1
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.tablature_id = ?
Parameters:
[
  1
]
0.30 ms
(10.02%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.path AS path_3, p0_.is_published AS is_published_4, b1_.id AS id_5, b1_.type AS type_6, b1_.content AS content_7, b1_.image AS image_8, b1_.section AS section_9, b1_.position AS position_10, b1_.page_id AS page_id_11 FROM page p0_ LEFT JOIN block b1_ ON p0_.id = b1_.page_id WHERE p0_.path = ? ORDER BY b1_.position ASC
Parameters:
[
  "/tablatures/tu-es-ma-lumiere"
]

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

Entities Mapping

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